Knowledge Base

"Object library not found" error or Excel X for Mac quits

Article ID: 322237

Article Last Modified on 2/1/2007

APPLIES TO

Microsoft Excel X for Mac

This article was previously published under Q322237

SYMPTOMS

When you open a Microsoft Excel workbook, you receive the following warning message

The workbook you are opening contains macros.

Some macros may contain viruses that could harm your computer.

If you are sure this workbook is from a trusted source,
click 'Enable Macros'. If you are not sure and want to
prevent any macros from running, click 'Disable
Macros'.

and one of the following symptoms may occur:

If you click Enable Macros, you receive the following error message:

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

After the workbook is open, you cannot record a macro.

-or-
If you click Disable Macros, Microsoft Excel quits unexpectedly.

CAUSE

This problem may occur when you move the Users folder to another partition or hard disk that is not the Mac OS X startup disk or partition. It may also occur if the Users folder is redirected to another computer such as a server.

RESOLUTION

To resolve this issue, use either of the following methods:

Move the Users folder back to the hard disk partition that contains Mac OS X.

-or-

Reformat your hard disk to have a single partition.

MORE INFORMATION

If Mac OS X is installed on one partition, and you move your Users folder to a different partition, the Microsoft Visual Basic for Applications environment does not initialize correctly. As a result, macros cannot run in the file that you open, you cannot record macros, and Microsoft Excel may quit unexpectedly if you disable macros when you open the file.

Additional query words: MacXLX Mac XLX vb automation automatic visual basic virus err msg alert open start

Keywords: kberrmsg kbprb KB322237

Microsoft KB Archive/322237

Contents