Protected Worksheet Tab Order
 

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?

Protected Worksheet Tab Order
 

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


On Wed, 24 Mar 2010 16:07:02 -0700, Ryan W.
wrote:

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?