Setting TAB to navigate to selected Cells Only

[Corey]

Is it possible to setup a TAB Order so that when you hit the TAB Button you
navigate to the Next Selected Cell. Not neccesarily the next cell, as it
could be 2 Rows down and 3 across.

Is this possible, How?

 

[Ragdyer]

One way is to use a named range.

See if this old post helps:

http://tinyurl.com/39vzv

 

[Ardus Petus]

Format>Cell>Protection, unckeck Locked for those cells you want to tab to
Tools>Protection>Protect sheet

HTH

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)