How do I suppress or disable Excel events / event procedures using VBA?
You want to open an excel workbook either through VBA or through Automation, without triggering any of its event procedures. Say for example, the workbook to be opened has some code that excutes when it’s opened, but you don’t want it to be executed. In that case, you suppress the events before opening the workbook, do the processing and enable the events when you finish.
Related Questions
- If there are multiple events with a common finish line, what happens if a participant decides to switch from one event to another?
- Can I write VBA procedures that use Windows API calls and DLL calls - and are compatible with both Excel 5 and Excel 95?
- What are the advantages of holding the event in a hospital, compared with other similar events which are not?
