A new version of the CERN-CA-certs package is available in the QA environment.
The new package removes the older certificates of the CERN Certification Authority. Please make sure to test your services and software with the new package.
Full details are available on the SSB entry: OTG0077330.

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: 3/10/2020
Last reviewed: 5/2/2022
Tools:
Send the page Send  |  Printable version Print