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!

Here is some information.

Note that certification only works in Excel 2000 and later.

http://msdn.microsoft.com/library/de.../odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default...;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/de...tml/combat.asp

Another reference:
http://msdn.microsoft.com/library/en...vbaproject.asp



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


http://office.microsoft.com/assistan...ustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP


Regards,
Tom Ogilvy

"rci" wrote in message
...
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!