Easily change Move selection after Enter option

[Paul S]

I regularly use some files for which I want the cursor to go Down after
pressing Enter, and others where I want it to go Right.

Is there an icon I can set up on a toolbar to allow me to change the
option very quickly ?

 

[Tim879]

try this
Sub Toggle_Enter_Key_Direction()
'
' Toggles enter key between moving right and down
' Macro recorded 2/25/2008 by T. Bradshaw
'
'

If Application.MoveAfterReturnDirection = xlToRight Then
Application.MoveAfterReturnDirection = xlDown
Else
Application.MoveAfterReturnDirection = xlToRight
End If


End Sub

 

[Paul S]

Tim879 wrote:

try this
Sub Toggle_Enter_Key_Direction()
'
' Toggles enter key between moving right and down
' Macro recorded 2/25/2008 by T. Bradshaw
'
'

If Application.MoveAfterReturnDirection = xlToRight Then
Application.MoveAfterReturnDirection = xlDown
Else
Application.MoveAfterReturnDirection = xlToRight
End If

End Sub

Thanks Tim, that works great.