Move selection after Enter

  • Thread starter Thread starter jswalsh33
  • Start date Start date
J

jswalsh33

Is the a way to set "Move After Return" not to move, at the workbook level.

I have a workbook with many sheets and Macros. No matter where I set the
Excel option Move selection after Enter, the clicking enter on the worksheets
still moves the selection in some way.

If not at the workbook level, is there a way at the worksheet level?

Thanks for your help.

Jim
 
That is a global setting found at Tools>Options>Edit.

Uncheck the "move after enter" option.

To disable at the workbook level you would have to disable in workbook_open
or worksbook_activate code then re-enable when workbook is closed or
de-activated.

Same method for a worksheet.

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

Private Sub Worksheet_Deactivate()
Application.MoveAfterReturn = True
End Sub


Gord Dibben MS Excel MVP
 
Back
Top