If you have a specific set of cells you want to tab through in a specific
order, you can select the cells using the ctrl key in the order in which you
want to tab through them. Then, go to the namebox and enter a name for the
range, sub as TabList

Now as long as the cells are selected, if you just hit the tab key, it will
follow that path. If you want to repeat this at a later time, go to the
name box, click the down arrow and select Tablist. then the cells will be
reselected with the previously established order.

--
Regards,
Tom Ogilvy

"IC" wrote in message
...
Is there a way to tab from one cell to one other specific cell? I need to
tab from B5 to F10 but G9:I9 are unlocked.

Ideally, I need to tab down a specific column (F, G, H or I) but cells are
unlocked in all these columns. I suspect this isn't possible.

I tried using a named range, but rows 12 and below contain code which is
activated on selection and the range selects the cells first.

Ian

"Tom Ogilvy" wrote in message
...
There is no setting that I am aware of that would alter this.

--
Regards,
Tom Ogilvy

"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