| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Temp Stop and Start Recording Macros. | Excel Worksheet Functions | |||
| How do I stop macro alerts for a spreadsheet with no macros in it | Excel Discussion (Misc queries) | |||
| linking of macros with other workbooks. need to stop it! | Excel Discussion (Misc queries) | |||
| How do I stop Macros from opening with every excel spreadsheet? | Excel Discussion (Misc queries) | |||
| How to stop macros in 2nd workbook? | Excel Programming | |||
![Joe 90[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
