Remove Macro security warnings for good

[salvo69]

I have arranged for a Batch script to run on my PC through MS Scheduler but the excel spreadsheet I want to open and run the Macro automatically will not work as it asks to "enable" or "disable macros"
I have changed the settings within the tools but after a few runs it changes back to Medium security, any ideas?

[DonkeyOte]

Group Policy in place perhaps ?

[salvo69]

Thanks for that

[shg]

You could sign your macro, unless group policy circumvents that.

See http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx
http://support.microsoft.com/kb/206637
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[royUK]

Which version of Excel? If 2007 you can set up a Trusted Folder