Excel doesn't pick event changes

[enfeizhan]

I am sorry this may sound like a Excel problem but I can't find answer any where.

My excel just can't pick up any changes in the spreadsheet. After a few hours frustration, I finally find Application.EnableEvents is set False by default once a new market is loaded in the spreadsheet. This is so bizarre as this problem didn't exist on my old computer.

Is there any way to make True by default?

[alrodopial]

somewhere in the VBA code there should be
Application.EnableEvents is =False
change it to True

[Daywalker]

In VBA open the Immediate window. Type Application.EnableEvents=true and press Return.

If you stop your code part way through, this remains false even if you reset your project. Whilst testing I always have this line in the Immediate window to quickly reset.