Taborder with unlocked cells in protected worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PO - 23 Jan 2008 15:46 GMT

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

Reply to this Message

Gord Dibben - 23 Jan 2008 17:26 GMT

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

>Excel 2003, sp2
>
[quoted text clipped - 6 lines]
>Regards
>Pete

Reply to this Message