Using The Visual Basic Editor

Exirs

When a worksheet containing a signed macro loads, you can specify that you want to always trust macros from that source by clicking the Always trust macros from this source option Ochanges to 0). If you select this option, Excel saves the name of the trusted source in the Trusted Sources tab of the Security dialog box. You can view the list of your current trusted sources by clicking ToolsOMacroOSecurity to display the Security dialog box and then select the Trusted Sources tab.

If at any time you no longer want to trust macros from a source listed on the Trusted Sources tab, you simply highlight the name of the source and click Remove. If you remove the source from the list, the next time you open a workbook with that source Excel prompts you to see if you want to open macros from that source.

Also on the Trusted Source tab you have two other options. To have Excel also warn you before opening installed add-ins and templates, remove the check mark for the Trust all installed add-ins and templates check box. To allow Excel to access all macros with your project without warning you, select Trust access to Visual Basic Project.

■ The Select Certificate

LS Click OK.

□ Close the workbook in Excel.

-■ Depending upon the type of certificate loaded, you see a message indicating that Excel is loading a signed macro.

■ The Select Certificate dialog box displays a list of available digital signature certificates.

-Q Click the desired certificate.

LS Click OK.

□ Click OK in the Digital Signature dialog box to save the settings.

□ Close the workbook in Excel.

Q Reopen the workbook containing the macro.

-■ Depending upon the type of certificate loaded, you see a message indicating that Excel is loading a signed macro.

Was this article helpful?

0 0

Post a comment