I have a sheet with ActiveX buttons; Each button has a password to open a specific sheet. When I click on any button it takes me to:
Private Sub Alpujarra_Click()
formContra.Show
End Sub
Private Sub btnAceptar_Click()
Clave = txtClave
Call Sedes
End Sub
Sub Sedes()
If Clave = "Alpu123" Then
Sheets("Alpujarra").Visible = True
Sheets("Alpujarra").Select
Unload Me
End if
My question is: How to validate Password and the button at the same time (which is the button corresponding to that password)? I hope you understand me, and you can help me.