tab order

[daolb]

can you specify a tab order in excel?


for example. can I specify the folowwing tab order:


b1
b2
b3
b4
b10
b11
b12

and ofcourse how?

gracias

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0008.html

--
HTH

Bob Phillips

"daolb" <[email protected]> wrote in
message news:[email protected]...
>
> can you specify a tab order in excel?
>
>
> for example. can I specify the folowwing tab order:
>
>
> b1
> b2
> b3
> b4
> b10
> b11
> b12
>
> and ofcourse how?
>
> gracias
>
>
> --
> daolb
> ------------------------------------------------------------------------
> daolb's Profile:
http://www.excelforum.com/member.php...o&userid=24478
> View this thread: http://www.excelforum.com/showthread...hreadid=382504
>

[Paul B]

daold, have a look here for one way,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"daolb" <[email protected]> wrote in
message news:[email protected]...
>
> can you specify a tab order in excel?
>
>
> for example. can I specify the folowwing tab order:
>
>
> b1
> b2
> b3
> b4
> b10
> b11
> b12
>
> and ofcourse how?
>
> gracias
>
>
> --
> daolb
> ------------------------------------------------------------------------
> daolb's Profile:
http://www.excelforum.com/member.php...o&userid=24478
> View this thread: http://www.excelforum.com/showthread...hreadid=382504
>

[swatsp0p]

The only way I know of would be to 'Unlock' the desired cells to tab into then Protect the sheet, allowing ONLY Select Unlocked Cells. Tabbing will then scroll through the unlocked cells.

HTH

Bruce