Signing Your Macros to Avoid Security Warnings

Macro security in Outlook 2007 gives you control over when macros can run, which helps prevent malicious code from affecting an Outlook 2007 user’s system. When macro security is set to Warnings For Signed Macros; All Unsigned Macros Are Disabled in Outlook 2007, only digitally signed macros from trusted sources can run. A setting of Warnings For All Macros causes Outlook 2007 to prompt you whether to enable and allow macros to run. A setting of No Security Check For Macros allows all macros to run, which poses significant risks from malicious code.

If you create your own macros, you probably would like to digitally sign your macros so that they will run on other people’s computers without triggering Outlook 2007 macro security warnings. Outlook 2007, like all versions since Microsoft Outlook 2000, provides the means to sign VBA projects.

To create a self-signing certificate, follow these steps:

  1. Choose Start, All Programs, Microsoft Office, Microsoft Office Tools, and then select Digital Certificate For VBA Projects.

  2. Type a descriptive name for your certificate, such as Outlook 2007 Code Signing Certificate, in the Your Certificate’s Name dialog box, and then click OK.

  3. Click OK to confirm creation of the certificate.

To sign a macro, follow these steps:

  1. In Outlook 2007, choose Tools, Macro, Macros, to open the Macros dialog box.

  2. Select a macro, and then click Edit to open the Visual Basic Editor.

  3. Choose Tools, Digital Signature to open the Digital Signature dialog box.

  4. Click Choose, select your code-signing certificate, and then click OK. Click OK again, and then close the Visual Basic Editor.

On the computer that will be running the macro, verify that you have configured Outlook 2007 macro security for either Warnings For Signed Macros; All Unsigned Macros Are Disabled or Warnings For All Macros settings, and then attempt to run a macro. When Outlook 2007 asks whether you want to trust the macro publisher, click Yes. Your custom macros should now run on that computer without triggering the Outlook 2007 security warnings.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset