Article ID: 262876
Article Last Modified on 11/5/2003
APPLIES TO
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q262876
SYMPTOMS
When you click a control on a worksheet that is assigned to a macro, you receive the following message:
-or-
When you click a toolbar button or custom menu item, you receive the following message
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:
- 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.
- Click OK.
- 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:
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
Additional query words: XL2000 OutlookSecurityUpdate
Keywords: kbprb KB262876
