High. This prevents Visual Basic for Application subprocedures and functions that have not been digitally signed from running. Cells that have user-defined functions display the #NAME? error value.
Method 1: Add a digital signature to the macroExcel 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:
- Open the file that contains the macro project that you want to sign.
- On the Tools menu, point to
Macro, and then click Visual Basic Editor.
- In Project Explorer, select the project that you want to sign.
- On the Tools menu, click Digital Signature.
- Click Choose, select the certificate, and then click OK two times.
Method 2: Change the security levelTo change the security level of macro virus protection:
- On the Tools menu, click
- Click the Security tab.
- Under Macro Security, click Macro Security.
- Click the Security Level tab, and then select the security level that you want to use.
Artikel-id: 813968 – senaste granskning 20 juni 2014 – revision: 1