Enable Macros automatically but only in a scheduled event

[scolivas]

I make and run macros all the time - now I need to schedule some reports to refresh from my machine round the clock. Problem is in order for the macros that do all my refreshing won't run unless I do one of 2 things - either reduce my security settings to low or actually click the button "enable macros".

If i re-set the security settings - I cannot get to the macro's to edit them if need be (they automatically close the application) Is there a way to force the code to stop once it's running outside the test environment? I would actually like to be able to see the report to make sure it's running properly from time to time.

I don't want to have to work 24 hours a day and come in and click the button every time it refreshes....

so is there a way to build into the excel document - that if no button is pushed - that it automatically will enable macros? (this would be the best option)



Thanks!

[SammyB]

You just need to sign your macros so that you can run them at your security level. Looks like http://www.excelsig.org/Tips/0409_di...rtificates.htm has a lot of links to how this is done. It's probably hard to figure out the first time, but easy after that. HTH --Sam

[scolivas]

You just need to sign your macros so that you can run them at your security level. Looks like http://www.excelsig.org/Tips/0409_di...rtificates.htm has a lot of links to how this is done. It's probably hard to figure out the first time, but easy after that. HTH --Sam

Thanks! I'll Check it out!

[Killer42]

Thanks! I'll Check it out!

So, how did it work out?