Disable Enter key in specific excel file

[Andreas1]

Hello to all!

Hope you can help me. I have an issue in an excel file that i want to disable 'enter' so users can navigate in excel sheets with arrows only.

is there a simple way to de-activate the enter key only for the specific excel file (lets call it test.xlsx

thanks!!
Andreas

 

[Yongle]

It is more complicated than you may may think and requires VBA
The command is simple enough

Application.MoveAfterReturn = False

BUT
- the property is set at application level NOT workbook level
- once set the property must either be reset to True or Excel closed and re-opened
- the workbooks requiring this need to be macro enabled
- the code must be placed in ThisWorkbook module of each relevant workbook (not a standard module)
- ensure that property set to False whenever workbook is active and to True when the workbook is either closed or deactivated

Private Sub Workbook_Open()
    Application.MoveAfterReturn = False
End Sub

Private Sub Workbook_WindowActivate(ByVal Wn As Window)
    Application.MoveAfterReturn = False
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.MoveAfterReturn = True
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
    Application.MoveAfterReturn = True
End Sub

 

[mikerickson]

Do you want the user to be able to enter values in cells?
If not, sheet protection will prevent that.

 

[Andreas1]

thank you so much Yoda! it works fine!