Hidden Tabs And Passwords

I have been doing a lot of reading on the forums here on hiding tabs and passwords for my current project...and suffice to say I am completely...totally...stuck.

Basically, I have 11 different tabs that need to remain hidden until, the person clicks on a commandbutton which brings up a userform that asks for a password.

Now - I have it set up that the user prior to this stage chooses thier location and it populates a label1 field on the password request userform.

My biggest problem is this: I cannot seem to figure out how, in using a userform, to get the password to be recognized as TRUE....here is the

Private Sub TextBox1_Change()
a = UserForm12.TextBox1

If a "password" Then
MsgBox "Wrong Password"
Sheets("RatesII").Visible = xlSheetVeryHidden
End If
End Sub

Now, my idea is that once the correct password is used, the userform dissmisses itself, the correct sheet is activated and unhidden for viewing and the user goes about doing what they do on this sheet. I will also have a button on the sheet itself titled something like "Update" which will save the sheet, and re-hide it and call up the userform once again...something I am a little scetchy on at this time though I immagine I will figure it out.