digital signature

[colin.eles]

I have an excel sheet that resides on a network drive, which is
supposed to run a macro when it starts up, however the users security
settings stop it from running. So I decided to try and get a digital
certificate from CACert, a free certificate place.
I have created a client certificate from CACert, and added it to my
personal certificates, but when I got to sign the excel vba project my
newly added certificate does not show up in the list.

If anyone has any idea why this CACert is not working, or how to
attach it to my excel project, or perhaps a better way to achieve the
same result it would be greatly appreciated.

 

[Gord Dibben]

No signature to choose from under VBE>Tools>Digital Signature?

Have you tried copying it into the Trusted Root Certicate folder in MMC?

Does it show up in your Tools>Options>Security>Macro Security>Trusted
Publishers?

How about Tools>Options>Security>Digital Signature>Add?

Is it recognized in that dialog?


Gord Dibben MS Excel MVP

 

[colin.eles]

No signature to choose from under VBE>Tools>Digital Signature?

Have you tried copying it into the Trusted Root Certicate folder in MMC?

Does it show up in your Tools>Options>Security>Macro Security>Trusted
Publishers?

How about Tools>Options>Security>Digital Signature>Add?

Is it recognized in that dialog?

Gord Dibben MS Excel MVP

No signature to choose from under VBE>Tools>Digital Signature? yes
that is correct

copying it into the root folder does not change anything.

no it does not show up in Tools>Options>Security>Macro
Security>Trusted Publishers.

but it does show up in Tools>Options>Security>Digital Signature>Add.

I think that I am missing some step, because when I make a cert with
selfcert it shows up
in the desired place. It is only when I am using this .p12 issued from
CACert that it does not work.

 

[Gord Dibben]

Have never had occasion to use CACert so can't speak to that.

I saw you posted over in programming group also.

Any response from that group?

The regulars there are more familiar with DS's than myself who has never signed
a project other than with selfcert for my own projects.


Gord