Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable SelectionChange Event
I have a spreadsheet which has code behind the SelectionChange event. When I
am working on (editing) the worksheet, I want the code active. Later, when I run a macro to do processing on the worksheet, I want this code deactivated. Is it possible to use EnableEvents and specify a specific workbook and/or worksheet and/or event (the SelectionChange event), or does EnableEvents always apply to the entire application? Is there anyway to disable a specific event, or is that ever really necessary? Does EnableEvents affect anything other than workbook and worksheet events? It seemed to bypass an InputBox sequence when I set it equal to false in one test. -- Bill @ UAMS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Start Excel Event ID 2001 | Excel Discussion (Misc queries) | |||
Using excel to manage event - ANY input deeply appreciated! :-) | Excel Discussion (Misc queries) | |||
Same event, multiple sheets? | Excel Discussion (Misc queries) | |||
Excel Automation SelectionChange event | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |