|Posted by davesexcel on November 11, 2012 at 5:45 AM|
If you want the user to enter a password before completing an action use a User Form.
How to make a userform click the link.
Create your userform and draw a textbox and two buttons on it.
Select the textbox and then in the properties window under PasswordChar enter * (astrix)
Use this code in the UserForm
Private Sub CommandButton1_Click()
If TextBox1 = "123456" Then
MsgBox "you have the correct password"
MsgBox "wrong password"
Private Sub CommandButton2_Click()
Private Sub UserForm_Initialize()
Me.Caption = "Enter Password"
You finish Password Userform