Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running excel macro by scheduler
With great help from you guys I created a macro which operates and refreshes
a group of pivot (cube) files. I am trying to operate this macro file by a scheduler few times a day. The only problem is the €œEnable macros" prompt. I cannot set the security level to low due to the organization rules. Any idea?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running excel macro by scheduler
Dan
Is the workbook just on your own computer? If so, you can create and sign the project with a digital signature using the SelfCert Tool from MS Office. See help on digital signatures. If need more info post back or see this google thread. http://tinyurl.com/2ajgdq Gord On Sun, 19 Aug 2007 13:14:01 -0700, Dan wrote: With great help from you guys I created a macro which operates and refreshes a group of pivot (cube) files. I am trying to operate this macro file by a scheduler few times a day. The only problem is the “Enable macros" prompt. I cannot set the security level to low due to the organization rules. Any idea?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run macro with scheduler | Excel Discussion (Misc queries) | |||
Excel running Word macro | Excel Discussion (Misc queries) | |||
Getting Task Scheduler To Use Current Excel Session When Opening F | Excel Discussion (Misc queries) | |||
Can I make multiple room scheduler (Excel) 15 minute increments? | Excel Discussion (Misc queries) | |||
Running a Macro automatically from Excel | Excel Worksheet Functions |