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 !