Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protected Worksheet
Is there a way to delegate the selection order of cells in a worksheet? I
have a protected worksheet with a few unlocked, selectable cells. I would like to have them filled out in a particular order. |
#2
|
|||
|
|||
Hi Kevin,
The only way I can think is to use validation. Are you familiar with it? Data - Validation. I'd use the formula option and basically restrict input on the current cell until such time as the previous cell (i.e. the one you want entered first) does not equal "". For example, A1 has to be populated before A2, therefore, with A2 selected I would go Data - Validation. Select "Formula" as the type and type the following formula: =A1<"". Hope this helps, Jon "Kevin" wrote: Is there a way to delegate the selection order of cells in a worksheet? I have a protected worksheet with a few unlocked, selectable cells. I would like to have them filled out in a particular order. |
#3
|
|||
|
|||
Jon, I am familiar with Validation and tried your solution
It performed exactly as I needed . I dont think I would have thought of using validation, I was expecting code. Many, many thanks. Kevin "Springbok" wrote: Hi Kevin, The only way I can think is to use validation. Are you familiar with it? Data - Validation. I'd use the formula option and basically restrict input on the current cell until such time as the previous cell (i.e. the one you want entered first) does not equal "". For example, A1 has to be populated before A2, therefore, with A2 selected I would go Data - Validation. Select "Formula" as the type and type the following formula: =A1<"". Hope this helps, Jon "Kevin" wrote: Is there a way to delegate the selection order of cells in a worksheet? I have a protected worksheet with a few unlocked, selectable cells. I would like to have them filled out in a particular order. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enable font color on protected worksheet? | Excel Discussion (Misc queries) | |||
Is it possible to sort a protected worksheet? | Excel Discussion (Misc queries) | |||
Sorting protected worksheet | Excel Discussion (Misc queries) | |||
How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |