XL98: Preferences Dialog Box Does Not Appear (193075)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q193075
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 Preferences 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 there is a corrupted global setting in the Preferences dialog box.

WORKAROUND

To work around this problem, follow these steps:
  1. Quit Microsoft Excel.
  2. Remove the following files located in the System Folder:Preferences folder on the hard disk:

    VBA Preferences
    Excel Settings (8)
    PPC Registration Database

  3. Restart Microsoft Excel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kbdtacode kberrmsg kbprb KB193075
©2004 Microsoft Corporation. All rights reserved.