Workbook_Open question

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

Guest

How do I open a workbook and bypass the Workbook_Open event? I already have
code in the procedure, but I forgot to comment it out for the next open.

Thanks
 
You could throw in an
Application.EnableEvents = False
before you open the workbook and then
Application.EnableEvents = True
afterwards
 
Application.EnableEvents = False
Workbooks.Open "C:\MyFiles\MyFile.xls"
Application.EnableEvents = True
 
You must log in or register to reply here.

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

Can't delete sheets 8
Unable to change ActiveSheet within Workbook_Open 2
How to open a specific worksheet via code from workbook_open 5
Creating named range in VBA problem 3
Open workbook without running Workbook_Open Event 4
Workbook_Open does not run for Addin 3
ActiveWorkbook is nothing in Workbook_Open 3
Application.quit error 3

Back
Top