You cannot. Would you really want a program to be able to change the
security settings!

The alternative is to create a digitally signed macros and /or set trusted
sources
--

Regards,
Nigel




"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