Prev: Automatically extend a list when adding a new data to another list
Next: EXCEL 2003 - SUBTOTALS
From: LaDonna on 25 Mar 2010 11:33
how can i force cell navigation in a specific order via the tab key? i have
done this before but it has been a while and i can't remember how i did it.
thanks for helping.
From: JLatham on 25 Mar 2010 11:45
Lock all cells on a sheet (they are by default).
Then unlock the cells you want to be able to automatically navigate to, and
Protect the sheet, unchecking the option permitting users to select Locked
cells.

I hope that's what you're looking for.

"LaDonna" wrote:

> how can i force cell navigation in a specific order via the tab key? i have
> done this before but it has been a while and i can't remember how i did it.
> thanks for helping.
From: Gord Dibben on 25 Mar 2010 15:14
See Jerry's reply about tabbing to unlocked cells on a protected sheet.

Note that Tab order to unlocked cells is always left to right then down,
left to right.

If you have some other Tab order you will need a named range or VBA.

See Bob Phillips' site creating a named range.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

If you want to entertain VBA method, post back.


Gord Dibben MS Excel MVP

On Thu, 25 Mar 2010 08:33:01 -0700, LaDonna
<LaDonna(a)discussions.microsoft.com> wrote:

>how can i force cell navigation in a specific order via the tab key? i have
>done this before but it has been a while and i can't remember how i did it.
>thanks for helping.

 | 
Pages: 1
Prev: Automatically extend a list when adding a new data to another list
Next: EXCEL 2003 - SUBTOTALS