Initialization Error Message When You Cancel the Installation of Visual Basic for Applications (813970)


The information in this article applies to:

  • Microsoft Office Excel 2003

SYMPTOMS

If you cancel the installation of Microsoft Visual Basic for Applications (VBA) in Microsoft Excel, you may receive an error message that is 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:
  • If VBA is set to install on first use when you install Excel or Microsoft Office.

    -and-
  • You have not yet used VBA in this installation of Excel or Microsoft Office.

    -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.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbprb KB813970
©2004 Microsoft Corporation. All rights reserved.