Solved

VBA not recognizing certificate

Posted on 2012-12-21
3
861 Views
Last Modified: 2013-01-12
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
0
Comment
Question by:HohmanCS
  • 2
3 Comments
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 38716146
what you probably should have done was revoke the invalid cert and then install the new corrected certificate.
0
 

Accepted Solution

by:
HohmanCS earned 0 total points
ID: 38751101
It was actually a problem with not being patched.  When I patched both machines they suddenly were able to see and use the certificate.
0
 

Author Closing Comment

by:HohmanCS
ID: 38769699
I found the solution myself.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB Script: split files based a intlines flag 27 54
word 2016 spell check 3 15
VBA Vbscript  Issue 9 25
Excel 2007 Macro to Change Column Formatting 3 33
This collection of functions covers all the normal rounding methods of just about any numeric value.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question