Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 levels of worksheet protection?
Hi,
Is it possible to have 2 levels of worksheet password protection? I have some cells unlocked (locked checkbox is not selected) this means all users can change these cells. I have then passowrod protected all worksheets so no other cells can be changed. However, I have a second level of user, whome I want to change additional cells, but not have the ability to change everything. A 3rd level of users should be able to change everything how do I do this? can it be done? thanks for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 levels of worksheet protection?
You can protect individual cell's with a password for the 2nd level users, so
you will have, Cells unlocked (for all) celss locked with a password require (2nd level) cells locked with a protection password hope this helps. regards from Brazil Marcelo "confused" escreveu: Hi, Is it possible to have 2 levels of worksheet password protection? I have some cells unlocked (locked checkbox is not selected) this means all users can change these cells. I have then passowrod protected all worksheets so no other cells can be changed. However, I have a second level of user, whome I want to change additional cells, but not have the ability to change everything. A 3rd level of users should be able to change everything how do I do this? can it be done? thanks for any help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 levels of worksheet protection?
Just to add...
This level of protection was added in xl2002. Marcelo wrote: You can protect individual cell's with a password for the 2nd level users, so you will have, Cells unlocked (for all) celss locked with a password require (2nd level) cells locked with a protection password hope this helps. regards from Brazil Marcelo "confused" escreveu: Hi, Is it possible to have 2 levels of worksheet password protection? I have some cells unlocked (locked checkbox is not selected) this means all users can change these cells. I have then passowrod protected all worksheets so no other cells can be changed. However, I have a second level of user, whome I want to change additional cells, but not have the ability to change everything. A 3rd level of users should be able to change everything how do I do this? can it be done? thanks for any help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |