Automating the depressing of ENABLE MACROS popup
I have a series of macros built into Excel that I would
like to put into a scheduler to run over night. However,
I can not get the macro to default to ENABLE MACROS,
thereofre someone needs to manually depress this button
to launch the Spreadsheet. I am aware that I cna chage
the level of security but for one reason or another this
is no good. Surely there is some VBA that can do this
for me?
Any help appreciated!
Cheers
|