We help IT Professionals succeed at work.

Renew VBA digital signature

Sid_P
Sid_P used Ask the Experts™
on
Hi,
A year ago I done some VBA on some Word docs for a company. They wanted a digital signed certificate for the docs. So they bought one from some company and I installed it (somehow, I don't remember on my PC) and then went to VBA Editor >> Tools >> Digital Signatures >> Choose >> selected the cert >> OK.

The cert has now expired. They've contacted me saying 'we renewed it we were provided with a unique ID number that now needs to be embedded into the macros document.'

I don't know how to do this :-(
Anybody know what is involved?
Any help appreciated,
Sid_P
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
You (or they) would need to install the new Certificate and then re-sign the document, just as you did the first time. Note you can also put a "time stamp" on the VBA Document so this doesn't happen again. This is a blog on the Thwate site (see the link below):

1. Create a 'Security' key at the VBA level: HKEY_CURRENT_USER\Software\Microsoft\VBA\Security

2. Add a String value Item to the 'Security' key named 'TimeStampURL' with the value set to: 'http://timestamp.verisign.com/scripts/timstamp.dll'

3. Add a DWORD value item to the 'Security' key named 'TimeStampRetryCount' with the value data set to '3' (In my case I used 3 but you can pick a different number).

4. Add a DWORD value item to the 'Security' key named 'TimeStampRetryDelay' with the value data set to '3' (In my case I used 3 but you can pick a different number).

From here:
https://search.thawte.com/support/ssl-digital-certificates/index?page=content&id=SO7492&actp=search&viewlocale=en_US&searchid=1278007998118

Author

Commented:
Hi,

Thanks for your reply.
The company haven't mentioned receiving a new Certificate, just a unique ID number.
Is this an actual new Certificate? Is it possibe to renew a Certificate?
It sounded to me, from their correspondance, that the Certificate had been renewed and they wanted me to apply the unique ID to the outdated one.

Can you clear this up?

Thanks,
Sid_P

Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
I'm not sure about that. I've always purchased the certificate myself, installed it on my machine, and used that cert to sign my projects. In general, that's the only way to sign a VBA project - the cert must be properly installed on your machine, and you must then sign the VBA project with that cert.