Suppress Worksheet_SelectionChange conditionally

  • Thread starter Thread starter IanC
  • Start date Start date
I

IanC

Is there any way to suppress Worksheet_SelectionChange in instances where
the selection change comes from a programmed command rather than user
action?
 
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.
 
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
 
Many thanks to B Lynn B & Tim Williams.

Application.EnableEvents = False does exactly what I need.
 
Back
Top