Disabling Macro-Virus check
 

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

--
s_s_sridha
-----------------------------------------------------------------------
s_s_sridhar's Profile: http://www.excelforum.com/member.php...fo&userid=1497
View this thread: http://www.excelforum.com/showthread.php?threadid=26602

Disabling Macro-Virus check
 

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