Tabs

[David]

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.

 

[Tom Ogilvy]

Select the last cell Now select the first to last cell in the order you wish
to proceed

in the name box give it a name like Order and hit enter

If you just use the tab to move between cells, it will follow this order
while the highlight remains. You can restore the highlight by selecting
order from the name box

 

[Gord Dibben]

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