How to digitally sign a VBA project
Posted on 2008-06-12
I am trying to add a digital signature to a VBA project that is to be used by internal users. I am using the signature to prevent the security warning, without having to lower the security settings. I setup CA on our Windows 2003 server, imported it on my machine withing IE. I open a test vba project and attempt to add th digital signature. At this point the only warning I see is when I look at the details of the certificate from within the VBA project is 'All the intended purposes of this certificate could not be verified.' At this point I try to save the project and get an error:
'There was a problem with the digital certificate. VBA project in the file ... could not be signed. The signature will be disgarded.
Is this a problem with the certificate itself. Do I need to generate a specific type? If so, how?