Setting TAB to navigate to selected Cells Only
 

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?

Setting TAB to navigate to selected Cells Only
 

One way is to use a named range.

See if this old post helps:

http://tinyurl.com/39vzv

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Corey" wrote in message
...
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?

Setting TAB to navigate to selected Cells Only
 

FormatCellProtection, unckeck Locked for those cells you want to tab to
ToolsProtectionProtect sheet

HTH
--
AP

"Corey" a écrit dans le message de news:
...
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?

Setting TAB to navigate to selected Cells Only
 

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

--
HTH

Bob Phillips

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

"Corey" wrote in message
...
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?