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 |
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 |
Can't run workbook with a macro from an 'at' command
Thanks, that worked fine...
John Stevens "Jeff Davis" wrote in message ... Another possible solution would be to configure the 'at' command to use a specific user account instead of SYSTEM. If Win2k, you can do this with Control Panel, Scheduled Tasks, Advanced Menu, and "AT Service Account". XP is the same except the Scheduled Tasks folder is under "Performance and Maintenance" in Control Panel. -----Original 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 . |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com