Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2002: Initialization Error Message When You Cancel the Installation of VBA

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

View products that this article applies to.

This article was previously published under Q287104

↑ Back to the top

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)

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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

↑ Back to the top

Keywords: KB287104, kbprb, kbpending, kberrmsg

↑ Back to the top

Article Info
Article ID : 287104
Revision : 6
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 302