Password protecting a user form

[ducecoop]

How would I code a button on a userform to request a password input before opening the form?

And as a second level of protection - can I code it to only display asterick's when typing in the password.

Any help here will be appreciated.

Thanks in advance
Dave

[shg]

Bring up another form with a textbox for the user to enter a password. See Help for the PasswordChar property of a TextBox control.

[ducecoop]

Thank you - I will try looking at that

[royUK]

Just use the UserForm intialize event

Option Explicit

Private Sub UserForm_Initialize()
    Const pw   As String = "secret"    '<- change this
    Dim ans

    ans = Application.InputBox("Enter password to continue")
    If pw = "" Or ans <> pw Then Unload Me
End Sub