VBA Worksheet Protection Coding Help

Hi all,

I'll admit now, i'm rather stuck!

I need help with coding to implement the following protection for my workbook;

Excel Workbook:
Standard workbook with the Sheet 1 labelled "home" and 2 additional worksheets available

Actions:
1. Open WB -> Password prompted, only "home" worksheet visible
1.1. Enter Admin password -> all worksheets unhidden
1.2. Enter pw1, pw2 -> only Sheet1, Sheet2 etc. unhidden (1 corresponding worksheet unhidden for every password other than "Admin") in addition to "home" sheet

2. Incorrect password -> prompted to try again
2.1. Incorrect password twice -> workbook closes

3. Exit workbook -> all worksheets bar "home" are (very)hidden

4. Bonus step: VBA code is password protected

Conditions:
1. "home" sheet/tab always visible
2. "admin" password unlocks all sheets
3. pw1, pw2 unlock only corresponding worksheets (sheet1, sheet2)
4. upon closing workbook all tabs bar "home" are very hidden
5. upon opening workbook, only "home" tab visible, and incorrect password entered twice closes workbook

I REALLY appreciate any help!

Many thanks,

Excelophobe

Problem is i need help writing the code.

I have used the veryhidden function to hide tabs on closing and created a user form and programmed the command button to open select tabs based on pw. I don't know how to do action 2;

2. Incorrect password -> prompted to try again
2.1. Incorrect password twice -> workbook closes

Nor am i sure if i should be doing the whole thing through the userform or an input box. Does that make any sense?

That's great. Thank you very much!