Workbook_Open question
 

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

Workbook_Open question
 

You could throw in an
Application.EnableEvents = False
before you open the workbook and then
Application.EnableEvents = True
afterwards

Workbook_Open question
 

Application.EnableEvents = False
Workbooks.Open "C:\MyFiles\MyFile.xls"
Application.EnableEvents = True

--
Regards,
Tom Ogilvy


"Sheldon" wrote in message
...
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