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 ToolsOptionsEdit.

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


On Wed, 24 Jun 2009 16:26:01 -0700, jswalsh33
wrote:

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

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

Jim

"Gord Dibben" wrote:

That is a global setting found at ToolsOptionsEdit.

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


On Wed, 24 Jun 2009 16:26:01 -0700, jswalsh33
wrote:

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