Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_change event
The Worksheet_change event seems to have stopped firing for me. I am
running Windows XP, Excel 2002 and have applied all currently released patches. I have confirmed that Calculation is set to automatic in Tools-Options, and ApplicationEnableEvents is True. I have security set to medium and selected enable macros when prompted. The workbook I'm using has a Worksheet_change event that worked for quite a while - long enough that I had to look in my comments to see when I last made a change to it. Now, for some reason, it simply isn't firing. I put a MSGBOX in as the first line of the Worksheet_change sub, and it is never reached. Is there something in a recent patch that is causing my problem, or is anyone aware of something else that might have changed to cause this? Let me be clear about this - I haven't made any changes to the VBA in this workbook for quite a while. I just opened it one day, entered data and found that the event didn't fire. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controling the Worksheet_Change Event? | Excel Discussion (Misc queries) | |||
Worksheet_Change Event | Excel Programming | |||
Problem with Worksheet_Change event | Excel Programming | |||
Worksheet_Change Event | Excel Programming | |||
Worksheet_Change Event Not Working | Excel Programming |