View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Open Worbook and Disable Macros

If you want to suppress a Workbook.Open Event

Application.EnableEvents = False
workbooks.Open "C:\MyFolder\Mybook.xls"
Application.EnableEvents = True

This doesn't disable events in the workbook, but it does stop the open event
from running. Leave events disabled if you want to suppress other events.

--
Regards,
Tom Ogilvy

"DMc2005" wrote in message
...
I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros.

D