Signed macro?

[Pat]

I created my first macro a couple of days ago, and although it works fine,
when I run it I get a message about the macro not being signed, and then a
message saying:

"There was a problem with the digital certificate. The VBA project could
not be signed. The signature will be discarded.... Microsoft Visual Bases,
File Not Found."

Would creating a digital certificate (using the SelfCert.exe tool) correct
this? Is it a good idea to do?

Assuming so, once I create this, how do I actually "sign" the macro?

Thanks for any help. I'm obviously new to this.

Pat

 

[Rod Gill]

Hi,

Yes using a certificate from Selfcert.exe does work, but only for you. In
the VBE select Tools, Digital Signature and add the self certificate you
created.

 

[Pat]

Thanks Rob.

One other question. If I want to live on the dangerous side, is there a way
I can disable the signature checking so I don't get the messages?

Thanks, -Pat

 

[Rod Gill]

I think the lowest macro security level. Personally I always use the Signed
Certificate.

 

[Pat]

Thanks Rod. Do you use self-signing (via SelfCert.exe) or some other?