To install object librariesIf you cannot find the locale you want to use listed in the Language/Country box on the Module General tab in the Options dialog box (Tools menu), you must install and register the corresponding object libraries. Visual Basic in Microsoft Excel requires two object library files for each language: the Microsoft Excel object library and the Visual Basic for applications object library.
For specific information about the names of the object library files and how you acquire the files, see the appropriate Help topics.
To install object libraries
If someone gives you an application written in another language and includes the object library files, those files are registered automatically when you try to run any of the procedures in the application. However, if you write code and use the object libraries for the first time, you must register them with Microsoft Excel yourself. Registering files means making Microsoft Excel aware that they exist. You only have to register an object library once, unless you move or rename one or both files.
To register a new language version of the object library files
1. Switch to a Visual Basic module.
2. On the Tools menu, click References.
3. Click Browse.
4. In the Look In box, click the name of the folder that contains the new Microsoft Excel object library file.
5. Double-click the object library filename.
(Repeat steps 3 through 5 for the Visual Basic object library file.)
6. Click OK to close the References dialog box.
You can now click Options on the Tools menu, click the Module General tab, and select the locale you want.
If the language you want still isn't available, Microsoft Excel has already assigned a language to your workbook. You should open a new workbook and repeat the preceding steps. Remember, you can assign a language to a workbook only once, as explained in "Working in Multiple Locales" earlier in this appendix.