Protected Worksheet Tab Order

[Ryan W.]

I have a protected worksheet in Excel. After I protected the sheet I selected
a range of cells that users could edit. When the sheet is protected the tab
order for the range of cells that the user could edit will not work, I can
nagivate using the arrows but not by tabbing. Does anyone know how to set the
tab order on a protected worksheet?

 

[Gord Dibben]

You must select the range of editable cells BEFORE you protect the sheet.

Format these cells to "unlocked" then protect the sheet.

Tab order will be left to right then down, left to right.

If you have some other Tab order you will need a named range or VBA.

See Bob Phillips' site creating a named range.

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

If you want to entertain VBA method, post back.


Gord Dibben MS Excel MVP