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