XL2000: Changed Macro Behavior with Excel Files

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.

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:

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:

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 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: