Protecting a worksheet in multiple steps? Code + Example

Hi all,

I'm trying to set up protection on my excel sheet.. and the way I imagine it, would be, when someone opens the workbook, they have to input a password, if they don't or the password isn't correct, they can only observe the workbook, and can't even select cells or do anything. Then if the password is correct, the next .Protect gets applied. Which allows some things but not everything, and to get the Sheet completely unprotected, there would be a button which will ask for the Admin Password and that will unprotect it completely, so the structure is okay but.. its just not exactly right as I code it...

Can I get some help with this please?

Here is my code, and my exact question within:

Please Login or Register  to view this content.

I also attached the workbook called "Protect" which has the same code in it. You will have to run the macro from the VBE now as I commented out the Auto_Open.

Question posted on Mr.Excel Message Board as well. Link: https://www.mrexcel.com/forum/excel-...ml#post5256606