| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Non standard protection requirement
If I have three people who share a worksheet, can I implement worksheet
protection so the Person 1 can only edit cells in range1, Person 2 can edit in range2 only, and likewise Person 3 only has rights to edit cells in range3. This will be most useful to me if it can be done. If it can not be accomplished, letting me know will be useful. Many thanks Marsh |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Non standard protection requirement
ToolsProtectionAllow users to edit ranges may do what you want.
Gord Dibben MS Excel MVP On Fri, 19 Jan 2007 13:40:02 -0800, Marsh wrote: If I have three people who share a worksheet, can I implement worksheet protection so the Person 1 can only edit cells in range1, Person 2 can edit in range2 only, and likewise Person 3 only has rights to edit cells in range3. This will be most useful to me if it can be done. If it can not be accomplished, letting me know will be useful. Many thanks Marsh |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Non standard protection requirement
That did it. Thanks
"Gord Dibben" wrote: ToolsProtectionAllow users to edit ranges may do what you want. Gord Dibben MS Excel MVP On Fri, 19 Jan 2007 13:40:02 -0800, Marsh wrote: If I have three people who share a worksheet, can I implement worksheet protection so the Person 1 can only edit cells in range1, Person 2 can edit in range2 only, and likewise Person 3 only has rights to edit cells in range3. This will be most useful to me if it can be done. If it can not be accomplished, letting me know will be useful. Many thanks Marsh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plotting means and standard deviations I already have | Charts and Charting in Excel | |||
| Standard deviation calculation | Excel Worksheet Functions | |||
| Error when save as CSV with VBA password protection on | Excel Discussion (Misc queries) | |||
| An FAQ that never seems to be answered: autofiltering with protection on... | Excel Worksheet Functions | |||
| workbook protection | New Users to Excel | |||
Linear Mode
