Solved

VBA not recognizing certificate

Posted on 2012-12-21
3
874 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 81

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

728 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