Protect cells with different passwords to allow levels of authority

Please purchase the course before starting the lesson.

With the previous protect sheet methods you had 2 states. Either the person knows the password and can change any cell, or they don’t and they can’t change the locked cells. But you can also specify a password per cell or range of cells. This way only certain people can change certain cells.

 

Lesson tags: vlookup
Back to: Excel for Human Resource and Payroll Personnel > Protecting spreadsheet information and formulas