Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't run workbook with a macro from an 'at' command
I have an 'at' command that runs a .bat command that runs Excel (2000 and
2002 SP-1), opening a workbook with a macro. Except that Excel hangs on opening, apparently at the macro security dialog. The .bat file runs fine when run from a user logon (as opposed to SYSTEM), when I have the macro security level set to LOW. How do I set the default macro security level for Excel? TIA John Stevens |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't run workbook with a macro from an 'at' command
You can't set it with code - that would defeat the purpose.
Logon as SYSTEM and set the security to low if that is what you want. The setting should be retained for system I would think. -- Regards, Tom Ogilvy "John Stevens" wrote in message ... I have an 'at' command that runs a .bat command that runs Excel (2000 and 2002 SP-1), opening a workbook with a macro. Except that Excel hangs on opening, apparently at the macro security dialog. The .bat file runs fine when run from a user logon (as opposed to SYSTEM), when I have the macro security level set to LOW. How do I set the default macro security level for Excel? TIA John Stevens |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't run workbook with a macro from an 'at' command
I can't figure out how to log on as SYSTEM.
However, Jeff Davis' suggestion worked... John Stevens "Tom Ogilvy" wrote in message ... You can't set it with code - that would defeat the purpose. Logon as SYSTEM and set the security to low if that is what you want. The setting should be retained for system I would think. -- Regards, Tom Ogilvy "John Stevens" wrote in message ... I have an 'at' command that runs a .bat command that runs Excel (2000 and 2002 SP-1), opening a workbook with a macro. Except that Excel hangs on opening, apparently at the macro security dialog. The .bat file runs fine when run from a user logon (as opposed to SYSTEM), when I have the macro security level set to LOW. How do I set the default macro security level for Excel? TIA John Stevens |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
this command is not available in a shared workbook | Excel Worksheet Functions | |||
Assign macro name to menu command w/o using workbook name | Excel Discussion (Misc queries) | |||
VBA Code to kick off macro when workbook command to close is initi | Excel Discussion (Misc queries) | |||
Disable a command from with in a workbook | Excel Programming |