save the macro in a vbs (vb script file)
assuming your anti virus setup allows execution of vbs scripts
office will run it without any prompts.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


s_s_sridhar wrote:


Hi All,
I have written a Excel Macro. The security option is medium. Hence when
ever I open the excel file it is asking me to select either Enable or
Disable macro. I would like to put this excel in windows scheduler for
automation. I do not want to get this macro-virus check option because
human interaction is not possible in this case. And, I do not what to
put the security option to low.

Therefore only for this excel file, it should not display the macro
enable/disable prompt. Can any body help me.

Thanks in advance.
Sri