XL2002: Initialization Error Message When You Cancel the Installation of VBA (287104)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q287104

SYMPTOMS

If you cancel the installation of Microsoft Visual Basic for Applications (VBA) in Microsoft Excel, you may receive an error message similar to the following:
An error occurred initializing the VBA libraries (1004)

CAUSE

This behavior can occur when all of the following conditions are true:
  • When you install Excel or Microsoft Office, VBA is set to install on first use.

    -and-
  • You have not yet used VBA in this installation.

    -and-
  • You click Visual Basic Editor under Macro on the Tools menu, and then click No when prompted to install VBA.

RESOLUTION

To prevent this issue from occurring, follow these steps to install VBA:
  1. Start Excel.
  2. On the Tools menu, point to Macro, and then click Visual Basic Editor.
  3. When prompted to install VBA, click Yes.

MORE INFORMATION

For additional information about problems that may occur when VBA is not installed, click the article number below to view the article in the Microsoft Knowledge Base:

287105 XL2002: Excel Opens Workbook in Repair Mode when Workbook Contains Macros

Modification Type:MinorLast Reviewed:9/12/2006
Keywords:kberrmsg kbpending kbprb KB287104
©2004 Microsoft Corporation. All rights reserved.