XL2002: Macro High Security Warning or User Defined Functions Display #Name? (277608)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q277608

SYMPTOMS

When you start Microsoft Excel or open a workbook, you may receive the following or similar error message:
Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security levels. Click Help for more information.
When you change something on a workbook, or force a recalculation, some cells display the #NAME? error value.

CAUSE

By default, Microsoft Excel sets macro security to high, which prevents Visual Basic for Application sub procedures and functions that have not been digitally signed from running. Cells that have user-defined functions display the #NAME? error value.

WORKAROUND

To work around this behavior, use either of the following methods.

Method 1: Adding Digital Signature to Macro

Excel runs macros that are signed by a trusted source. Obtain a digital signature, and then add the digital signature to the macro. To add the digital signature, follow these steps:
  1. Open the file that contains the macro project that you want to sign.
  2. On the Tools menu, point to Macro, and then click Visual Basic Editor.
  3. In the Project Explorer, select the project that you want to sign.
  4. On the Tools menu, click Digital Signature.
  5. Click Choose, select the certificate, and then click OK twice.

Method 2: Changing the Security Level

To change the security level of macro virus protection, follow these steps:
  1. On the Tools menu, click Options.
  2. Click the Security tab.
  3. Under Macro Security, click Macro Security.
  4. Click the Security Level tab, and then select the security level that you want to use.

MORE INFORMATION

For more information about macro security, click Microsoft Excel Help on the Help menu, type about macro security in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

REFERENCES

For additional information about how to obtain and use digital signatures, click the article numbers below to view the articles in the Microsoft Knowledge Base:

217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects

206637 OFF2000: Overview of Digital Certificates

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbdtacode kberrmsg kbpending kbprb KB277608
©2004 Microsoft Corporation. All rights reserved.