VBA not recognizing certificate

HohmanCS
HohmanCS used Ask the Experts™
on
We have a certificate server and issue code signing certificates to our VBA persons, we had a problem with a bad certificate getting installed so we went through and deleted and installed the correct one.  Once we did this VBA does not see the certificates any longer?  I can go into other computers and it works fine, but on the machine where I deleted and re-added it does not recognize the cert in VBA.  If I try to add the cert in Word it sees the cert.  I added the cert through CertMgr.msc and it looks fine.  This is a process on a new machine that works fine but on ones where we deleted old cert and re-added it's not working.  When i go to choose cert in VBA is says "No Certificate Available"

I have attached screen shots.
VBA.png
Word.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
what you probably should have done was revoke the invalid cert and then install the new corrected certificate.
Commented:
It was actually a problem with not being patched.  When I patched both machines they suddenly were able to see and use the certificate.

Author

Commented:
I found the solution myself.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial