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