View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Disable macros in Workbooks.open

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

--
Regards,
Tom Ogilvy


"mps" wrote:

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