tabbed movements
 

I know there is a way to use the tab key to move from one specific cell to
another nonadjoining specific cell - just don't know how...
thanks for any help

tabbed movements
 

Under cell format, protection, you can unlock a cell.
When a sheet is protected (and you allow unprotected cells to be selected),
"tab" moves from one unprotected cell to the next, skipping the protected one.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"alpineuser" wrote:

I know there is a way to use the tab key to move from one specific cell to
another nonadjoining specific cell - just don't know how...
thanks for any help

tabbed movements
 

Couple of methods for "tab"bing or "enter"ing to cells can be found at Bob
Phillips' site.

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

There is also a couple of VBA methods.

Post back if interested in one.


Gord Dibben MS Excel MVP

On Tue, 8 Sep 2009 12:18:07 -0700, alpineuser
wrote:

I know there is a way to use the tab key to move from one specific cell to
another nonadjoining specific cell - just don't know how...
thanks for any help