Taborder with unlocked cells in protected worksheets

[PO]

Excel 2003, sp2

Hi,

When you lock cells in a worksheet you can jump between the unlocked cells
using the TAB key. Is there any way to influence the tab order (without
having to use a lot of code)?

Regards
Pete

 

[Gord Dibben]

When using the unlocked cells method your order can only be left to right and
top to bottom.

There are other methods...........one of which is using a named range with no
protection.

See Bob Phillips' site for this method.

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

Other methods would use VBA code.


Gord Dibben MS Excel MVP