Easily change Move selection after Enter option

P

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 ?
 
T

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
 
P

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
'
'
Click to expand...
If Application.MoveAfterReturnDirection = xlToRight Then
Application.MoveAfterReturnDirection = xlDown
Else
Application.MoveAfterReturnDirection = xlToRight
End If

End Sub
Click to expand...

Thanks Tim, that works great.
 
Top