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 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!

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