Digitally signing macros

[Joe4]

Conversation with Greg Truby, posted for the benefit of others (and with his permission):

Greg,

I have been searching this forum regarding digitally signing macros. I see that it looks like you are using them in an office setting.

I write a lot of macros that we distribute around the office and the "Enable Macros" prompts confuses and/or annoys many users.

I see that to get an "Authentic Certification" requires effort and money, but it appears from your e-mails that you are successfully using the SelfCert. I have a few questions regarding this:

1. Can you use this in an office setting? It appeared to me that it would only work for the signer on his computer. Does that mean everyone would need to sign and save a copy of the file for themselves?

2. In one of the posts it mentions that it self-signing might not work if the macro creates or deletes files. Is that true? Many of my macros create new worksheets.

 

[UMAKEMESIK]

i just tried it on another computer. it open's it up just fine but the macros don't work.

my digital signature is in the document so I am a bit confused why I never get the dialog box asking to load the certificate.

 

[KWD]

This procedure works great for Excell 2003, but ever since I have gone to Excel 2007 I can not get my digital signitures to work.

Any ideas?

 

[Greg Truby]

This procedure works great for Excell 2003, but ever since I have gone to Excel 2007 I can not get my digital signitures to work.

Any ideas?

It's not working very cleanly for me in 2007 either. I can sign my own stuff and then I can open without problems. But I cannot seem to accept the Self-Cert signatures from other's signed workbooks. Even if I jump through all the hoops and successfully import the certificate, when I attempt to open the workbook, the "always trust..." checkbox is disabled. grrrr! Will post back if I figure out what's going on.