Sometimes the macro security level in Excel is set at medium
I'm wondering what is changing the security level. If you've got a User
that's messing with settings, that's where you need to start.
One other possibility is to create a Visual Basic program that contains all
your macros (most macros will port directly into VB6 Classic with the
addition of objects set to the application and file). Then open the
VB exe
with Scheduler and have that open the Excel file and do stuff.
Ed
"John" wrote in message
...
You can't do that I'm afraid Carl .... It rather defeats the purpose of
macro security :-)