Microsoft Outlook 2013: VBA project signature verification failed

Question

After computer reset, I wanted to use my VBA macros for Outlook 2013.

An error message appears in Outlook:

"An error occurred while trying to verify the signature of the VBA project. Macros will be disabled."

Therefore, the VBA editor states:

"Macros in this project are disabled. [..]"

I tried:

• Developer → Macro Security → (*) Enable all macros (not only digitally signed)

• Define a certificate using

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

Nothing succeeded. Any idea?

Answer 1

Ok, I found the cause of my problem:

(1) The nameofmycert certificate from selfcert.exe was assigned to my VBA project.

(2) However, I did not assign it to a trusted authority, as shown in: https://technet.microsoft.com/en-us/library/cc754841.aspx#BKMK_addlocal

(3) Outlook has been configured to allow all macros (not just digitally signed). One way or another, he discovered that my VBA project was certified, but was not sure if the validation was correct, due to (2). Therefore, he disabled all macros.

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

 Certificate name: [no certificate] Sign as: nameofmycert 

Removable cotton has been decontaminated.

Decision:

(1) VBA / Tools / Digital Signature

(2) Click Choose .. and select a certificate. Then the removed cotton is activated.

(3) Click Remove Certificate

(4) Save VBA project

(5) Restart Outlook

Answer 2

Catching it right now, this is how I ended up solving it (none of the other suggestions worked for me):

• Create your own certificate - I called my "Self Cert" (generated here in Office 2013 - C: \ Program Files (x86) \ Microsoft Office \ Office15 \ SELFCERT.EXE)
• Run certmgr.crt from the Start menu and copy "Self Cert" from "Personal \ Certificates" to the folder "Trusted Root Certification Authorities \ Certificates"
• Open Outlook.exe as Administrator
• Open VBA (i.e. Developer -> Visual Basic)
• Open the module containing the VBA code
• Select Tools → Digital Signature → Select ...
• Select “OK” to select “Self Cert” (then VB shows the project as signed with this certificate), then click “OK” again to accept and close the window
• Click to save the macro in VBA - actually click on the save button in VB (strange it breaks if you don't explicitly save here)
• Close VBA
• Close Outlook and select "Yes" to save the VBA project.
• Restart Outlook.exe again as Administrator
• Either now, or after you run "Developer → Visual Basic" again, a window appears with a hint about the new macro - I clicked the "remember" button and I don’t suggest again
• Now macros should work! I use them as part of an email rule, and now it works great.

I'm not sure you need to start Outlook as an administrator above, but now it works without starting an administrator, so I'm happy.

Thanks to this resource so that it works for me! Basically, I just updated, consolidated and expanded the answers. https://social.technet.microsoft.com/Forums/en-US/07f0158c-085b-4031-93a1-c9d047cf855c/unable-to-sign-outlook-2010-vbaproject?forum=outlook

Answer 3

I had the same problem and this solution was fixed here: https://social.technet.microsoft.com/Forums/en-US/07f0158c-085b-4031-93a1-c9d047cf855c/unable-to-sign-outlook- 2010-vbaproject? Forum = outlook . The stream is long, but its essence is that you need to manually save the VBA project after signing and before exiting the VBA editor. Scroll down about 2/3 of the way to the message "Diane Poremsky [MVP]".

Answer 4

You need to change the settings of the trust center (run all macros, not just digitally signed) or purchase a valid certificate from a trusted authority.