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
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.