Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Can I change the tab order in a protected worksheet? | Excel Discussion (Misc queries) | |||
On a excel protected worksheet, how do I change the tab order? | Excel Worksheet Functions | |||
assign cell selection order in protected Excel worksheet | Excel Discussion (Misc queries) | |||
How to change the tab order for a protected worksheet | Excel Worksheet Functions |