View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James Russell James Russell is offline
external usenet poster
 
Posts: 1
Default Protection with different passwords

I have a worksheet that I use for a staffing schedule (a column of name
followed by columns of dates). I have protected each ropw with a password
(that person's initials) simply to avoid them changing the wrong schedule by
acident. However, when they open the sheet, some are required to input the
password (when they try to use the drop-down list on the protected row) and
some are not. I cannot figure out why all don't have to input a password.

More info: Each row's password is different (for instance, John Smith's
name is follwed by 28 days of cells with drop-down lists for input of
shifts). To eidt those cells, a password box pops up and you would endte
"js". Simple, not complicated (and could be changed by anyone, not just John
Smith). Each row is protected in a similar manner. Why would all not need
to follow the same rules???

Any help is greatly appreciated.
--
Jim