Move selection after Enter

[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

 

[Gord Dibben]

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

 

[jswalsh33]

Thanks for your response. That was the code I needed.

Jim