Microsoft KB Archive/129155

= XL: Error or Options Dialog Box Does Not Appear =

Article ID: 129155

Article Last Modified on 7/23/2007

-

APPLIES TO


 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q129155



WARNING: The information in this article has not been confirmed or tested by Microsoft. Some or all of the information in this article has been taken from unconfirmed customer reports. ANY USE BY YOU OF THE INFORMATION PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this information "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.



SYMPTOMS
The following problems may occur:


 * When you click Options on the Tools menu, the dialog box does not appear.

-or-
 * When you insert a module sheet, you may receive the following error message:

VBA English/Standard (VBAEN.OLB) object library not found.



CAUSE
This behavior may occur when either of the following conditions are true:


 * The Vba.ini file is missing.

-or-
 * There is a corrupted global setting in the Options dialog box.



WORKAROUND
To work around this problem, use the method appropriate for your situation.

Method 1: Microsoft Excel 7.0 Running Under Windows 95

 * 1) Quit Microsoft Excel.
 * 2) Click Start, and click Run.
 * 3) Type "regedit" (without the quotation marks) and click OK.
 * 4) Find the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Microsoft Excel
 * 1) Select each key that starts with "Options" and click Delete on the Edit menu.

Method 2: Microsoft Excel 5.0 Running Under Windows 3.1

 * Quit Microsoft Excel if it is running. In File Manager, rename the following files

Windows\System\Vba*.*

Windows\System\Vba*.bak

Excel\Xlen50.olb

Excel\xlen50.bak

and then reinstall Microsoft Excel.

-or-
 * In File Manager, look for the Vba.ini file in the Windows directory. If it is missing, click Run on the File menu. Type "regedit /v" (without the quotation marks) and click OK. You must manually enter the following section in the Windows registry:

1.0 = Visual Basic for Applications

To find the correct information, look at the registry on a computer that is working. Type in the section the way it appears on the working computer.

For additional information about editing Reg.dat, please see the following article in the Microsoft Knowledge Base:

124596 : "Cannot Find VBAEN.OLB" Creating New Macro or Module Sheet

Method 3: Microsoft Excel 5.0 Running Under Windows 95

 * 1) Quit Microsoft Excel if it is running.
 * 2) Find a computer that is working.
 * 3) Click Start, and click Run.
 * 4) Type "regedit" (without the quotation marks) and click OK.
 * 5) Find the following registry key:

HKEY_CLASSES_ROOT\TypeLib\{000204F3-0000-0000-C000-

000000000046}\1.0\9\win16 @="C:\\WIN95\\SYSTEM\\VBAEN.OLB"
 * 1) On the Registry menu, click Export Registry File.
 * 2) Type a file name and click OK.
 * 3) Go to the computer that is not working.
 * 4) Click Start, and click Run.
 * 5) Type "regedit" (without the quotation marks) and click OK.
 * 6) On the Registry menu, click Import Registry File and import the file created in step 6.

Method 4: Microsoft Excel Version 5.0 for the Macintosh
Remove the following files

  Visual Basic for Applications Preferences Microsoft Excel Settings (5) PPC Registration Database Registration Database,

and then restart the Macintosh.

Additional query words: 5.00c tools options dialog box menu available unavailable doesn't appear nothing happens XL97 XL7 XL5 missing show

Keywords: kbdtacode kberrmsg kbprb KB129155

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.