EXCEL VBA USERFORM- PASSWORD PROTECTION for worksheets, workbook and code

[PANTECH]

I have a userform that needs 3 levels of password protection. First there are 5 users of this userform.

1) The first level is for the 3 people that need userform access only(they are to have no spreadsheet access).
2) The second level is for 1 person who should be able to access the userform and "sheet 3" only(sheets 1 & 2 need to be blocked from this user).
3) The last level is all access for myself (administrator access).

I have attached my workbook!

[davesexcel]

To get things started, use this link to create your password userform.

http://www.davesexcel.com/apps/blog/...enter-password

[PANTECH]

Thanks, but I don't see how this gives me the three levels I am looking to acheive.

[nickmax1]

you could try to edit my code in this thread:

http://www.excelforum.com/excel-prog...fic-users.html

[PANTECH]

No the password box needs to open as soon as they click on the file folder. The first level user would after typing in his passowrd go directly to the userform access only(they are to have no spreadsheet access). The second level user after typing in his password would go to the userform and be able to see "sheet 3" only(sheets 1 & 2 need to be blocked from this user). The third level is all access for myself (administrator access).

I attempted to lock the project and that password came up too late so I unlocked it. There has to be a way to do this.

[PANTECH]

Attempted below but did not work....

Option Explicit

Sub ShowForm()
Const PW As String = "secret"

If InputBox("Enter password to continue") = PW Then
frmINVENTORY.Show
Else: MsgBox "Wrong password"
End If
End Sub