Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Worksheet_SelectionChange conditionally
Is there any way to suppress Worksheet_SelectionChange in instances where
the selection change comes from a programmed command rather than user action? -- Ian -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Worksheet_SelectionChange conditionally
Application.EnableEvents = False
Insert just before the line of code that would otherwise trigger the event. Make sure you always get it set back to True before code stops executing, whether by error handler or before end/exit sub. "IanC" wrote: Is there any way to suppress Worksheet_SelectionChange in instances where the selection change comes from a programmed command rather than user action? -- Ian -- . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Worksheet_SelectionChange conditionally
You could try
Application.EnableEvents = False 'make your selection changes Application.EnableEvents = True Or, if you have access to the code, you could insert a check in your Worksheet_SelectionChange code to check the value of a global variable and exit without any action if required. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If DoNothing Then Exit Sub '....other code here End Sub Tim On Apr 15, 10:52*am, "IanC" wrote: Is there any way to suppress Worksheet_SelectionChange in instances where the selection change comes from a programmed command rather than user action? -- Ian -- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Worksheet_SelectionChange conditionally
Many thanks to B Lynn B & Tim Williams.
Application.EnableEvents = False does exactly what I need. -- IanC -- "IanC" wrote in message ... Is there any way to suppress Worksheet_SelectionChange in instances where the selection change comes from a programmed command rather than user action? -- Ian -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming |