Assign 2 different values/behaviours to a key

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