View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sankar Sankar is offline
external usenet poster
 
Posts: 3
Default Automatically enable the macros when a excel file is opened

Hi,
I have an excel workbook with a macro. My requirement is to schedule to run
the macro in this workbook. I am using a batch command to open the excel book
and would be scheduled in the windows scheduled tasks.

When this excel sheet is opened it pops up the message to "disable" or
"enable" macros. Is there a way that I can automatically run the macro
without this message. I would not be able to change the security level of
macro to "Low" which is the commond option suggested by Microsoft and else
where.

Your inputs will be appreciated and greatly helpful.

Thanks,
Sankar