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
|