| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Protection
Hi everyone,
Difficult question but easy to someone who knows. I know how to protect a sheet and how to lock/unlock cells so they can be edited once the sheet is protected but... How do you protect a range of cells so they can be edited using a password whilst still leaving the rest of the sheet available for input? It baffles me. Can any one help...........please. Many thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range Protection
If you're using xl2002+, you can use:
tools|protection|Allow users to edit ranges. Phil Gilligan wrote: Hi everyone, Difficult question but easy to someone who knows. I know how to protect a sheet and how to lock/unlock cells so they can be edited once the sheet is protected but... How do you protect a range of cells so they can be edited using a password whilst still leaving the rest of the sheet available for input? It baffles me. Can any one help...........please. Many thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| Using Named Range with protection on the worksheet | Excel Discussion (Misc queries) | |||
| Protection : More than 1 range protected ?? | Excel Worksheet Functions | |||
| Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Linear Mode
