Trusted Sources/Digital Certificates/Macro Security Problem Solved

K

Ken Grubb

Hopefully this solution will help others enduring the same problem.

SELFCERT.EXE allows me to create a Digital Certificate, and I can add
that Digital Certificate to ThisOutlookSession (VbaProject.OTM), but
my Digital Certificate does not show up under Trusted Sources.

The workaround is a registry hack, but it's fairly easy and pain-free.

Run REGEDIT.EXE, and go to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VBA\Trusted

Create a New Binary Value, and name it what you named your Digital
Certificate. Now the tricky part. You need to set the Binary Data to
the Thumbprint of your Digital Certificate. To see the Thumbprint of
your Digital Certificate, in Outlook, ALT-F11, Tools, Digital
Signature, Detail, Details, and scroll down to Thumbprint. I was able
to copy the Thumbprint [into Clipboard], but I could not paste it into
the Binary Data field in the Registry. Had to manually type. But
once it's there, your Digital Certificate is included in your Trusted
Sources so you won't be prompted to Enable Macros every time you run
Outlook, and you can bump Macro Security Level back up to High.

HTH,

Ken Grubb
Bellevue, WA, USA
 
B

Blue

Ken,

Do you know of a way to find out the thumbprint of other Digital
Certificates?

BLUE
 
K

Ken Grubb

Blue said:
Do you know of a way to find out the thumbprint of other Digital
Certificates?

The Binary Data values in the other entries at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VBA\Trusted I presume contain
the thumbprints of other installed Digital Certificates.

Ken Grubb
Bellevue, WA, USA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top