Vba to not move down one cell after pressing enter for the current workbook only

[omairhe]

Hey everyone, I need to run a code that would disable cell movement when Enter is pressed. I am aware of Excel's built-in feature but that will work for all workbooks. However, I want it to work for the active workbook only.

Will appreciate any help on this.

 

[Legacy 456155]

I'm not sure what other consequences this will have.

Private Sub Workbook_Activate()
    'disable Enter key
    Application.OnKey "{RETURN}", ""
End Sub

Private Sub Workbook_Deactivate()
    'enable Enter key
    Application.OnKey "{RETURN}"
End Sub