View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 110
Default diabling the macro alert in opening files

I have scheduled a task in my computer for opening a workbook at a particulr
time and run the macro in thisworkbook.open event in that workbook
the macro was designed by me so there is not much chance of getting an
external virus. in those circumstances i would like to run the schedule and
the computer should not ask whether to enable the macros.


.. I understand that displayalerts=false works only after the macro starts
to run. and not while opening the file.and before running the macro


any suggestions.