Disable macros in Workbooks.open

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

Guest

In a macro in Workbook_A, I call workbooks.open("Workbook_B"). Although I am
(obviously) running macros in Workbook_A, I don't want to run Workbook_B's
startup macros when it is opened (but they are). How can I disable macros in
the load of Workbook_B?

Thanks,

Mike
 
application.EnableEvents = False
workbooks.Open "Workbook_b.xls"
application.EnableEvents = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close WorkBook 5
How to Change Source Data after copy sheets from another workbook? 3
Saving Worksheets 2
Run Macro If Cell have "x" value 0
help with VBA program to import and add formatted files to one file 0
Disable Workbooks_Open() Macro when opening from VBA 1
Workbooks.Open suppresses MsgBox Displays when Macro is run 4
Error 13 in 'WorkBooks.open' 4

Back
Top