You might want to looking into using Selfcert.exe to certify your workbook
(3rd link).

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

should be applicable to xl2000 and later.

--
Regards,
Tom Ogilvy

"Carl" wrote in message
...
I have an Excel file that is started automatically by Task Scheduler. The
Excel file runs some macros upon opening. Sometimes the macro security
level
in Excel is set at medium so the auto-open macro must wait for the user to
enable the macros before continuing. This defeats the whole purpose of the
project. Is there any way to have the auto-open macro set the macro
security
to minimum first? (I doubt it because this would defeat the whole purpose
of
macro security settings but had to ask). Thanks.