vbaoutlookcertificateoutlook-2013

Microsoft Outlook 2013: Error verify VBA project signature


After a computer reset I wanted to use my VBA Macros for Outlook 2013.

In Outlook I get the error message:

"An errror occured while attempting to verify the VBA project's signature. Macros will be disabled."

Consequently the VBA editor states:

"The macros in this project are disabled. [..]"

I have tried:

  1. Developer -> Macro Security -> (*) Enable all Macros (not only digitally signed)

  2. Define a certificate using

    C:\Program Files (x86)\Microsoft Office\Office15\selfcert.exe
    

Nothing worked. Any idea?


Solution

  • Ok, I found the reason for my problem:

    (1) The Certificate nameofmycert by selfcert.exe was assigned to my VBA project.

    (2) However I didn't assign it to a trusted authority, like seen in: https://technet.microsoft.com/en-us/library/cc754841.aspx#BKMK_addlocal

    (3) Outlook was set to allow all macros (not only digitally signed). Anyhow it found that my VBA project was certified, but was not sure if the cerification is correct, because of (2). Therefore it deactivated all macros.

    (4) In VBA/Tools / Dignital Signature it appeared:

    Certificate name: [no certificate]
    Sign as: nameofmycert
    

    The remove-botton was deactivated.

    Solution:

    (1) VBA/Tools / Digital Signature

    (2) Click on Choose .. and select a cerificate. Then the remove-botton is activated.

    (3) Click on Remove Certificate

    (4) Save VBA project

    (5) Restart Outlook