Putting a scroll right and scroll down tab on the taskbar

Question

I have spreadsheets where I want to move down on row when I hit enter and I have them where I want to move right. How can I make a button to put on my taskbar that I can click to change the direction?

hansvogelaar · Answer

Create the following macros in a module in your personal macro workbook PERSONAL.XLSB, then assign them to custom buttons on the Quick Access Toolbar (QAT):
Sub EnterMoveDown()
    Application.MoveAfterReturnDirection = xlDown
End Sub

Sub EnterMoveRight()
    Application.MoveAfterReturnDirection = xlToRight
End Sub
See Create and save all your macros in a single workbook if you're not familiar with the Personal Macro Workbook.

Forum Discussion

Putting a scroll right and scroll down tab on the taskbar

1 Reply