VBA macros excel [closed]

1

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.

    
asked by Diablo 25.08.2016 в 21:07
source

0 answers