View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe 90[_2_] Joe 90[_2_] is offline
external usenet poster
 
Posts: 30
Default How to stop macros in 2nd workbook?

Thanks

It works a treat+ACE- as follows:

Application.EnableEvents +AD0- False
Workbooks.Open Filename:+AD0AIg-C:+AFw-myfile.xls+ACI-
Application.EnableEvents +AD0- True


Joe

+ACI-Jim Rech+ACI- +ADw-jrrech+AEA-hotmail.com+AD4- wrote in message
news:eD68PTSuDHA.2208+AEA-TK2MSFTNGP10.phx.gbl...
Use Application.EnableEvents +AD0- False prior to opening the workbook. Reset
it afterward.

--
Jim Rech
Excel MVP