Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing thru User-Edit Cells in Protected Sheet
In a protected spreadsheet I have allowed user-edit for a range A10:B20.
However when the user tries to tab from A10 to B10; the tab does not take them to column B. How can I configure the user-edit cells so that the user can tab from column A to column B? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing thru User-Edit Cells in Protected Sheet
Hey,
I am having the exact same problem. If you let a user change a specified range, they should be able to do everything they normally could within that range. "ConfusedNHouston" wrote: In a protected spreadsheet I have allowed user-edit for a range A10:B20. However when the user tries to tab from A10 to B10; the tab does not take them to column B. How can I configure the user-edit cells so that the user can tab from column A to column B? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabbing thru User-Edit Cells in Protected Sheet
Hey,
I was just messing around and I figured this out. Do this before you protect it. Take your range of A10-B10 and format the cells, choose the last tab "Protection" and take the checkmark off of "Locked". Then apply your protection. "ConfusedNHouston" wrote: In a protected spreadsheet I have allowed user-edit for a range A10:B20. However when the user tries to tab from A10 to B10; the tab does not take them to column B. How can I configure the user-edit cells so that the user can tab from column A to column B? Thanks |
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) | |||
Tabbing on a Protected worksheet | Excel Worksheet Functions | |||
Edit links when the sheet is protected | Excel Discussion (Misc queries) | |||
tabbing in a protected sheet | Excel Discussion (Misc queries) | |||
how do you check and edit spelling on a protected sheet. | Excel Discussion (Misc queries) |