The question was for the tab key, which those settings do not affect.

--
Regards,
Tom Ogilvy

"Don Lloyd" wrote in message
...
Ian,
This changes the direction after pressing the ENTER key,

Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlDown (ToRight, ToLeft, Up)

Regards,
Don


"IC" wrote in message
...
I'm sure it's been asked (and answered) a hunderd times before but, is
it
possible to change the tab direction so that instead of the tab key
moving
to the next unlocked cell to the right, it moves to the next unlocked
cell
down?

Many thanks in advance for any and all input.

Ian