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