SlinkRN
Well-known Member
- Joined
- Oct 29, 2002
- Messages
- 715
Is there a way to protect some cells even when sheet is "unprotected"? I've created a template that many different staff will be entering input with different levels of access. I would like supervisors to have the ability to change any cells except for the headings and formulas etc. and staff to be able to change only their specific 2 rows of cells. I've password protected the staff cells individually, and I figure the supervisors can just unprotect the sheet to change anything that staff put in. My problem is that once the sheet is unprotected, the supervisors may erase a formula or constant cell by mistake. Any ideas? Can a userrange have 2 passwords?
This message was edited by SlinkRN on 2002-11-12 15:33
This message was edited by SlinkRN on 2002-11-12 15:33