How to disable Macros in VBA code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
just a guess, try:

Application.DisplayAlerts = False, for the second query, and it should work
for the first if your security setting is set to medium beforehand. If it is
low, the macros will be enabled directly without promting.

at the start.


Mangesh
 
Back
Top