Assign 2 different values/behaviours to a key

[Wizz]

Hi,
I need to give 2 different behaviours to the {ENTER} key. If the {ENTER} key is pressed on sheet "Test", it should pop out a msgBox. Everywere else it should act as a normal {ENTER} key.

So far I used the following code to catch up when enter is pressed.

Please Login or Register  to view this content.

On the procedure "myEnterBehaviour" I check the worksheet name and then take an action. Poping Up the msgBox is no problem; my problem is making it act normal ! How can I Achieve that?

My Code so Far:

Please Login or Register  to view this content.

Thanks !

[antoka05]

Try to put this code only in "Test" sheet so it will call myEnterBehaviour sub only for that sheet

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards,
Antonio

[Wizz]

Gracias Antonio !
The problem with this approach is when the following happen

1.Sheet "Test" activate
2.User deactivate macros
3.Moves to another sheet or workbook
4.activate macros or run a macro throug a button.

I was using that approach, but now I need something more 'user proof' !