Tricky... Macro Security!

[rci]

Hi all...

Macro security is important... turning it off can be dangerous...

HOWEVER

For TRUSTED files... is there a way to attach a signature or some form of
validation to a file or path that allows macros to run WITHOUT prompting the
user to "Enable Macros" when security is set to medium?

Thanks!

 

[Tom Ogilvy]

Here is some information.

Note that certification only works in Excel 2000 and later.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288985
XL2002: About Digital Signatures in Excel Workbooks


http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

An Overview:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo00/html/combat.asp

Another reference:
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrsigningvbaproject.asp



http://support.microsoft.com/default.aspx?scid=kb;en-us;Q329228
OFFXP: How to Make Sure That Your Office Document Has a Valid Digital
Signature


http://office.microsoft.com/assistance/2002/articles/otelldigitalcertiftrustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP


Regards,
Tom Ogilvy