Tab to next cell?

[francis]

Help! My boss wanted me to revise someone else's Excel
document. I put in everything I was supposed to add, but
I can't figure out how to re-set the tab order. The way
the other person had it, after you entered one cell the
tab key would take you to the next cell you needed to
fill. This isn't working any more and I can't figure out
how he set this up! I'm using Excel 2002 Please help!

 

[Cutter]

If the sheet is protected you can tab from one unlocked cell to th
next, bypassing all the locked cells in between. To unlock a cel
click on Format>Cells>Protection and remove the check in front o
Locked. Then to protect the sheet click on Tools>Protection>Sheet (
password is optional)

 

[Gord Dibben]

Francis

Several ways to do this.

See the info here at Bob Phillips' site.

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

There is another method which involves VBA Worksheet event code. If
interested in that, post back.

Gord Dibben Excel MVP