Help
Skip Navigation Links.

How to Sign Office Macros

This page explains how to sign Microsoft Office macros.

Prerequisites

To sign Microsoft Office macros, you need to:

  1. Get a Code Signing certificate.
  2. Install the certificate in your Personal certificate store, to be able to sign your macros.
  3. Install the certificate in your Trusted Publishers certificate store, so that your system trusts your signed macros.

How to sign macros (example with Outlook)

For security reasons, your Office installation should be set not to execute unsigned macros:

If you want to execute your own macros, you will need to sign them with a code signing certificate.

  1. Customize the Ribbon so that you can see the Developer Tab:
  2. From the Developer tab, select the "Visual Basic" button.
    Visual Basic for Applications will open.
  3. When your Macros project is open, select Tools -> Digital Signature...
  4. Choose your Code Signing certificate:
  5. Select your code signing certificate and click Ok.
    If you don't see your certificate, you need to install it in your Personal certificate store.
  6. Save your Macros project, and restart Outlook. Your macros should now execute.

Created: 2/13/2017
Last reviewed: 9/10/2019
Tools:
Send the page Send  |  Printable version Print