Macro Digital Signature

[Milodie66]

I am having an issue with a macro within a workbook I am sending out to other
people. I have no issue running the macro, but when someone tries to open,
they get the error "Macros are disabled because the security level is too
High and digitally signed Trused Certificate is not attached to the Macros.
Request the macros be signed by the author using a certificate issued by a
Certificate Authority."

How do I get a signature issued by a certificate authority?

 

[ryguy7272]

Tools > Macros > Security > Medium. Save the file, reopen, click 'Enable
Macros' and you're in business.

Check this out when you have time:
http://support.microsoft.com/kb/288985

HTH,
Ryan---

 

[Kassie]

Lot's of companies do not allow security to be set to medium, and then for
obvious reasons. There is a way in which you can export a digital signature
and load it on the target machine, but I have lost my instructions

The best way is for the recipient to create a digital signature on his/her
side, and resign the workbook. However, any alterations to the workbook then
has to be done on that PC. If you alter the file on your PC, the digital
signature is scrapped, and the end user has to re-sign it again.

The end user runs selfcert.exe on his/her PC, and creates the signature.
Then open the file, disasble macros, click on <Alt><F11>, click on Tools,
Digital Signature, Choose and OK out. Save the file, close it and reopen,
and it works.

Maybe one of the guys can tell us how to pass on the original digital
signature?

 

[ryguy7272]

I think this will tell you what you want to know:
http://www.vbforums.com/showthread.php?t=285212
http://office.microsoft.com/en-us/excel/HA012317811033.aspx#1

Really? Many companies do not allow security to be set to medium? I've
worked at many different firms, all over the country, and never encountered
this. I couldn't do my job if I couldn't use VBA, and other automation
processes.

HTH,
Ryan---

 

[Kassie]

I suppose it depends on which country then? I am not interested in arguing,
I merely voiced my opinion based on my experience. Any case, thanks for the
links you posted, and yes, that did help me! For that I thank you.