This article has been archived. It is offered "as is" and will no longer be updated.
When you click a control on a worksheet that is assigned to a macro, you receive the following message:
The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.
When you click a toolbar button or custom menu item, you receive the following message
The macro 'macro name' cannot be found.
where macro name is the name of the macro assigned to the toolbar button or custom menu item.
The macro assigned to an event does not run when the event occurs.
NOTE: You do not receive a message that the macro code behind the event did not run.
Your macro security level has automatically been set to High.
This behavior occurs if you have installed the OutlookE-mail Security Update. The Outlook E-mail Security Updateprovides additional levels of protection against maliciouse-mail messages. The update changes the way thatOutlook handles attachments and the way that Outlookcan be controlled programmatically.
For additional information aboutthis update, please see one of the following articlesin the Microsoft Knowledge Base, depending on whichversion of Outlook you have:
262631 OL2000: Information About the Outlook E-mail Security Update
262617 OL98: Information About the Outlook E-mail Security Update
To resolve this problem so you can run your Excel macros, follow these steps:
On the Tools menu, point to Macro, and then click Security.
On the Security Level tab, change your setting to either Medium or Low.
NOTE: The setting that you will want varies according to your circumstances. The default in Excel is Medium.
On the File menu, click Exit.
Start Excel and then open your workbook that contains the macros.
For additional information about security levels, click the article number below to view the article in the Microsoft Knowledge Base:
For more information about how other Microsoft Officeproducts may be affected by the Outlook E-mail SecurityUpdate, please see one of the following articles in theMicrosoft Knowledge Base, depending on which version ofOutlook you have:
262634 OL2000: Known Issues with the Outlook E-mail Security Update
262618 OL98: Known Issues with the Outlook E-mail Security Update