Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passwords | Excel Discussion (Misc queries) | |||
Passwords | Excel Discussion (Misc queries) | |||
changes and passwords | Excel Discussion (Misc queries) | |||
Passwords | Excel Discussion (Misc queries) | |||
passwords | Setting up and Configuration of Excel |