Cannot trigger macro with Worksheet_Change(ByVal Target As Range)

Hello,
I am not capable to make any Worksheet_Change(ByVal Target As Range) macro works. I tried several of them and none of them works in my Excel 2010. I boiled it down to the simplest version below, I studied several different treads on this forum and still nothing works. Any help is greatly appreciated.

Please Login or Register  to view this content.

The file is attached - again it simplified to single page, one cell which should be monitored by the macro.

So you know, the macro works for me, which leads me to believe it's not a coding issue. Are macros enabled? What are your security settings?

Well, then it is something in my Excel. Macro security is on "Disable all macros with notification". Regular VBA macros work. I just checked - closed and re-open file to enable macros. What it could be?

I added module with simplest macro

Please Login or Register  to view this content.

and it worked, so it is not just disabled macro. I know that I am an idiot but I checked...

maybe events are disabled
run this macro

Please Login or Register  to view this content.

and then check your Private Sub Worksheet_Change

Yes! It worked! How I can make it to work every time?
More correct question - are there any settings in Excel that do the same thing - Enable events?
Thank you very much for your help.

Nilem,

Nice thinking. I was stumped! {+ Reputation}

Leo,
it happens when the code contains

Please Login or Register  to view this content.

and if the code fails, events are still disabled. But it happens very rarely with the correct codes
BigBas, thanks

Nilem,
Thank you very much for help and explanations. I guess when my earlier versions of code failed, this disabled the events.
Leo