hit enter in any column and go to next row in first column
Your last statement is true only if your settings are to move down after
ENTER key is hit.
Set it to move right and it will move you across unlocked cells then down.
i.e. Unlock columns A and E
Protect sheet.
Select A1 and hit ENTER to move to E1 then A2 then E2
Gord Dibben MS Excel MVP
On Fri, 12 Jun 2009 08:52:01 -0700, gplant
wrote:
I want a macro so that when I hit {enter} the curser goes to the next row in
the first column.
I am not interested in doing this for the hole workbook, just one sheet.
I know about "tab tab tab enter", but sometimes I use arrows to move between
columns.
I fill in columns from B to AZ, but sometimes not all of them. I need to be
able to hit enter in column D or column Z or any column and have the curser
go to column A in the next row.
Protecting cells will not work ({enter} only goes to the next unprotected
cell in the same column).
Thank You!
|