Protecting sheet password

Hi friends

Need help in protecting worksheet with ADMIN password
no matter if Administrator ie "me" doesnt know the password has been changed by agents but i can again get into sheet with ADMIN password

their will be 2 password

1) ADMIN password ...to protect /unprotect sheet
2) Agent password ...to protect /unprotect sheet

i have not set any thing yet just working on blank sheet

please help me in code

thanks in advance

Hello, John!

You can use one technical password to operate with protection via VBA. And two user-oriented passwords that might be typed in Inputbox. In attachment you will see hidden list "Gear" with User and Admin passwords. "Admin" pass for admin and "User" for user.

Please Login or Register  to view this content.