Assign 2 different values/behaviours to a key

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.

Application.OnKey "{ENTER}", "myEnterBehaviour"

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:

Private Sub Workbook_Activate()

    Application.OnKey "{ENTER}", "myEnterBehaviour"

End Sub
'

Sub myEnterBehaviour()
    If ActiveSheet.Name = "Test" Then
       MsgBox "You just pressed Enter"
        
    Else
      'Act like a normal ENTER key - Here is where I need the help. !!!
      
    End If
    '
End Sub
'

Thanks !

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

Private Sub Worksheet_Activate()
   Application.OnKey "{ENTER}", "myEnterBehaviour"
End Sub

Private Sub Worksheet_Deactivate()
   Application.OnKey "{ENTER}"
End Sub

Regards,
Antonio

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' !