Signing a macro

[Steven]

I have a macro I use for a spreadsheet and every time I open the workbook,
it gives the warning about it being disabled because my security is too
high. I want to keep my security high, for macros I use that I did not
write. So how can I set it up to avoid that? How can I "sign" it or whatever
it takes?

TIA

Steven

 

[Tim Williams]

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=194

 

[zz]

you can create a certificate of your own, look in the office programs folder
then find "selfcert.exe"

follow the steps to create your certificate,

then in your macro editor, select the digital signature from the tools menu

 

[Jon Peltier]

Keep security at Medium. You are still asked whether to enable macros in the
workbook, so something cannot run without your approval.

- Jon