Write a VBS (or other) script that creates an instance of Excel that then
opens your workbook. Macros in it will be enabled regardless of the user's
security settings. You can have your code called from the Workbook Open
event in the workbook or you can use RUN to execute the code.
--
Jim
"Denis" wrote in message
...
|I need to automate some Excel processing via macros so that a job can
| just be scheduled to run without any user involvement. For this to
| work, macros have to be enabled. Unfortunately, I know of only one
| way to do this that doesn't involve interaction from the user -
| setting the security level to low.
|
| Is there any other way around this? Ideally, there would be a command
| line option that would enable macros but I haven't found anything.
| Setting the security level to low will obviously work but it's not a
| good solution. Any other possibility?
|
| Denis