View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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!