Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to turn events on or off?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to turn events on or off?
Angus,
You can disable events with code like Application.EnableEvents = False ' your code here Application.EnableEvents = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Angus Comber" wrote in message ... Hello I am using a Worksheet_SelectionChange event which is very useful. however, it is a bit of a pain if it fires off right at the start of my code. So is there any way to disable event handling and then when say a process is finished turn it on again? Angus Comber |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
events? | Excel Discussion (Misc queries) | |||
events | Excel Programming | |||
events | Excel Programming | |||
Code to automatically turn on and turn off Track Changes | Excel Programming | |||
Order of events | Excel Programming |