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