David

You cannot change the order in which the Tab key navigates unlocked cells.

An alternative method can be seen at Bob Phillips' site.

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

You can also use Worksheet Selection_Change Event code if you wish. Post back
if required.

Gord Dibben Excel MVP

On Sat, 21 Aug 2004 06:34:39 -0700, "David"
wrote:

I have a worksheet that I use as an invoice for my
customers. I have locked all of the cells except for the
ones that I enter data into. After I protected the
worksheet, everything works just fine with the exception
of one thing. I would like to change the order of the
cells when I push the tab button. In other words, the
tab defaults to the cell to the right instead of the cells
below it like I would like. Does anyone have any idea how
to do this. Thanks in advance for the help.