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!
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!
Comment