Microsoft Excel
--
Questions
--
Followers
Top Experts
Need VBA certificate
I would like to get a VBA certificate, and when reading a Microsoft Knowledge base article, they mentioned I could get a free one. Now I find this hard to believe, but perhaps someone knows of a place where I can. I would be passed throughout the business network, but we are not at a point to set up our own certificate authority. Is there a way to get a free VBA digital certificate so I can sign macros I write and set my users Macro security to high?
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
The self cert application is personal use only ... it is only recognised on teh pc where it is created so will not likely be much use for your requirements other than as a local simplification and for test purposes. The MS link is here http://support.microsoft.com/kb/217221/en-us though you may have already here.
I'm afraid you need an independant certificate as you mentioned in your post as it is installed on teh providers sites and accessible to other users in that way as it is validated by either the providers certificate or if your company sets up a service then by your own certificate ... but I think that would apply to the internal network NOT external users in that case.
Chris
I'm afraid you need an independant certificate as you mentioned in your post as it is installed on teh providers sites and accessible to other users in that way as it is validated by either the providers certificate or if your company sets up a service then by your own certificate ... but I think that would apply to the internal network NOT external users in that case.
Chris
Note if the intention is to set up certification on your own server but you want to sign macros in teh interim then you can purchase a certificate from an agency, as suggested in teh other article on MS site and when you sign the macros they can be validated by the other users since their apps will check for the validity of the certifying agency and if validated they can be accepted and security set to high.
Chris
Chris
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Bigdoggit
Humble apologies to you and Kevin. Everything I ever read indicated self signing was for the local account only. I have followed Kevins instructions ... implicitly therefore I was not trusting Kevins word ... BIG mistake. You can indeed copy a selfcert, I guess it needs to be done on a one by basis rather than a cert store being recognised automatically ... but it may meet your needs as long as users do not change, (or save) the documents at all of course.
Chris
Humble apologies to you and Kevin. Everything I ever read indicated self signing was for the local account only. I have followed Kevins instructions ... implicitly therefore I was not trusting Kevins word ... BIG mistake. You can indeed copy a selfcert, I guess it needs to be done on a one by basis rather than a cert store being recognised automatically ... but it may meet your needs as long as users do not change, (or save) the documents at all of course.
Chris
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
oh, have to ask a question now - what if the user is going to change the file regularly, at rows to the excel worksheet, and save the changes. Will the selfcert.exe sign the code and not the whole file so these changes can be made, and as long as I do not change the vba code, all will work fine?
I just checked and that is correct. Apparently you are only signing the code and not the rest of the data. When the spreadsheet changes without code changes, it is still considered signed and will not prompt with the macro message.
However, every time you send code updates, it will have to be re-signed and the user will have to accept.
However, every time you send code updates, it will have to be re-signed and the user will have to accept.
thank you guys
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.