Disabling Macro-Virus check

[s_s_sridhar]

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

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

Thanks in advance.
Sr

 

[keepITcool]

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 >