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 Tools Course > Protecting spreadsheet information and formulas