Have you tried to open and run my attachment on post #16, and run the Sub EventEnabler ?
What is the result ? Or do you just copy and paste the code to your own file ?

As your code on post #19, you put the code in Worksheet_SelectionChange() event, that's why it is triggered only if you select the cell (F7).
You should put it inside Worksheet_Change() event.