View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ROHIT ROHIT is offline
external usenet poster
 
Posts: 38
Default How to disable Macros in VBA code

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