how to use same password on different userform on specicy worksheet?
- by user3736237
How to use same pw on different userform on specicy worksheet?
E.g worksheet 1 open userform1 & worksheet 2 open userform2, but both using same password?
This is the password
ElseIf Pw = "1234" Then
ImageNo = "PicGoh"
pwno = 2 Or pwno = 3
' ElseIf Pw = "1111" Then
' ImageNo = "PicGoh"
' pwno = 3
ElseIf Pw = "" Then
pwno = 0
Else
pwno = 1
End If
End Sub
Sub Mac3()
If pwno = 0 Then
Exit Sub
ElseIf pwno = 3 Then
UserForm2.Show
ElseIf pwno = 2 Then
UserForm1.Show
ElseIf pwno = 1 Then
MyVar = MsgBox("Wrong Password! Please Key In Your Password Again")
If MyVar = 1 Then
MacPw
Mac3
End If
End If
End Sub