Trusted Sources/Digital Certificates/Macro Security Problem Solved

  • Thread starter Thread starter Ken Grubb
  • Start date Start date
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
 
Blue said:
Do you know of a way to find out the thumbprint of other Digital
Certificates?
Click to expand...

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
 
Back
Top