XL2000: Changed Macro Behavior with Excel Files

Article translations Article translations
Article ID: 262876 - View products that this article applies to.
This article was previously published under Q262876
Expand all | Collapse all

SYMPTOMS

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.
-or-

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.

-or-

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.

CAUSE

Your macro security level has automatically been set to High.

This behavior occurs if you have installed the Outlook E-mail Security Update. The Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The update changes the way that Outlook handles attachments and the way that Outlook can be controlled programmatically.

For additional information about this update, please see one of the following articles in the Microsoft Knowledge Base, depending on which version of Outlook you have:
262631 OL2000: Information About the Outlook E-mail Security Update
262617 OL98: Information About the Outlook E-mail Security Update

RESOLUTION

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

REFERENCES

For more information about how other Microsoft Office products may be affected by the Outlook E-mail Security Update, please see one of the following articles in the Microsoft Knowledge Base, depending on which version of Outlook you have:
262634 OL2000: Known Issues with the Outlook E-mail Security Update
262618 OL98: Known Issues with the Outlook E-mail Security Update

Properties

Article ID: 262876 - Last Review: November 5, 2003 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbprb KB262876

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com