I need to make 2 sheets in my workbook hidden and only appear with a password.

[huntert]

I am using Excel 2003.

I have a workbook with about 20 sheets in it.
1. I would like the workbook to always open up with the first 2 sheets hidden.
2. I would like an administrator to be able to unhide those sheets, when prompted for a password to unhide.
3. After the administrator edits and saves and passes it to a normal user. When the normal user opens the file those 2 sheets should be hidden again.

Being able to set a different password for each sheet would be the best case, but if it can only be one password that is fine too.

I am assuming some VBA code is going to be necessary because excel lets you easily hide and unhide sheets and then lock the workbook but this doesn't do it for my situation. I need each sheet to have its own password and always be hidden by default so the administrator doesn't always have to rehide save and pass.

 

[huntert]

The below code works amazing. But it only minimizes the sheet and asks for a password. I need it to actually completely lock the sheet where no one can see it unless they have the password.

Private Sub Worksheet_Activate()
ActiveWindow.WindowState = xlMinimized
If InputBox("Enter Password for this sheet") <> "ABC" Then Sheets("Cust. Pricing").Activate
ActiveWindow.WindowState = xlMaximized
End Sub