| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Change Event | Excel Discussion (Misc queries) | |||
| Workbook open event not firing (both 2000 and XP) | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
| Workbook.Open Event Procedure not firing | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Threaded Mode
