View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default How to disable Macros in VBA code

HI
Use :
Application.enableEvents=false
open the WB
Application.enableEvents=true
This way, any associate events will not be fired.
Regards
Jean-Yves

"RoHiT" wrote in message
...
In my code, I create an Excel Application object during runtime. Using the
same, I open an workbook which has macros attached to its Workbook_Open
event. Is there a way, I could disable the execution of the macros

associated
with the Workbook.

Also, in case I try to open a readonly workbook through code, it asks for
confirmation whether the workbook should be opened as read only. Is there

a
way, I could skip this confirmation.


regards

RoHiT