View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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