2 levels of worksheet protection?

G

Guest

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

Guest

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top