Thread: On Change Event
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default On Change Event

Hi Jeanne,

Just to add to Student's response, in order to prevent the observed
behaviour, when events are disabled in the code, it is advisable to
re-enable events in an error handler, e.g:

'=============
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error GoTo XIT
Application.EnableEvents = False

'your code

XIT:
Application.EnableEvents = True
End Sub
'<<=============



---
Regards,
Norman


"Jeanne Conroy" wrote in message
...
Hi Group:

I created a macro to pop up a message box under certain conditions using
the
Workbook_Change property of a worksheet. However sometimes it seems to
stop
working. What could cause this?

JJ