Worksheet Change event not firing but Worksheet activate event does

[Raj]

Hi,

I have used two Worksheet events in coding: Change event and
Deactivate event.

Both the events run fine in my machine.

But in a friend's machine the worksheet change event does not fire but
the worksheet deactivate event does.
(When I checked application.enableevents in the Immediate window, it
returns true in both cases.)

How do I trouble-shoot the problem?

Please help with this specific problem as also pointers/tips for
trouble-shooting worksheet/workbook events.

Thanks in advance for the help.

Regards,
Raj

 

[Joel]

I t maybe the error setting in VBA is different on each machine. Check the
VBA menu

Tools - Options - General - Break on Error.

To debug the problem put a break point on the worksheet change line in the
VBA code by clicking on the SUB line and pressing F9. Then go back to the
worksheet and see if the you reach the break point. Then Press F5 to
continue or F8 to step through the code.

I suspect it the Break on Error option that is causing the problem.