Worksheet change event not firing
I have a form that enables events, then changes a cell's value, but no
event is generated.
Private Sub OK_Click()
Application.EnableEvents = True
ThisWorkbook.ActiveSheet.Unprotect
ThisWorkbook.ActiveSheet.Range("C10").Value = "Hello"
ThisWorkbook.ActiveSheet.Protect
Unload Me
End Sub
What's going on?
The cell gets changed, but no execution at all in the
Worksheet_Change() event handler.
|