XL2000: Changed Macro Behavior with Excel Files

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:
  1. On the Tools menu, point to Macro, and then click Security.
  2. 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.
  3. Click OK.
  4. On the File menu, click Exit.
  5. 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:
206637 OFF2000: Overview of Digital Certificates
More information
This problem does not occur with macro code from the following sources:
  • Workbooks that are saved in your XLStart folder (including your Personal Macro Workbook, which is saved in the XLStart folder)
  • Add-ins, as long as the Trust all installed add-ins and templates check box is selected on the Trusted Sources tab of the Security dialog box
  • Signed add-ins or signed workbooks with macros from trusted sources

    To view all trusted sources, point to Macro on the Tools menu and then click Security. Then, click the Trusted Sources tab in the Security dialog box.

    For more information about digital signatures, click the article numbers below to view the articles in the Microsoft Knowledge Base:
    217221 OFF2000: Using SelfCert to Create a Digital Signature
    206637 OFF2000: Overview of Digital Certificates
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
XL2000 OutlookSecurityUpdate

Article ID: 262876 - Last Review: 01/12/2015 16:49:49 - Revision: 4.0

  • Microsoft Excel 2000 Standard Edition
  • kbnosurvey kbarchive kbprb KB262876