Microsoft KB Archive/322237

= &quot;Object library not found&quot; 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.