Microsoft KB Archive/277608

= XL2002: Macro High Security Warning or User Defined Functions Display #Name? =

Article ID: 277608

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



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.

