View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wexler Wexler is offline
external usenet poster
 
Posts: 14
Default 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.