Hi.
I need a little help, I made a login screen before opening the excel file.
I wonder, how could I do that when you access the User login, go straight to your sheet access.
How could I do that each login to access your tab, noting that the User name and password is being conferred on a tab called password.
Each User would have to open their flap specifies.
User adminsitrador, see how I put below.
Code:
If USUARIO.Text = Plan1.Range("b12") And SENHA.Text = Plan1.Range("c12" Activate.Sheets ("Administrador")
Code:
Private Sub ENTRAR_Click()
If USUARIO.Text = Plan1.Range("b12") And SENHA.Text = Plan1.Range("c12") Or _
USUARIO.Text = Plan1.Range("b13") And SENHA.Text = Plan1.Range("c13") Or _
USUARIO.Text = Plan1.Range("b14") And SENHA.Text = Plan1.Range("c14") Or _
USUARIO.Text = Plan1.Range("b15") And SENHA.Text = Plan1.Range("c15") Or _
USUARIO.Text = Plan1.Range("b16") And SENHA.Text = Plan1.Range("c16") Or _
USUARIO.Text = Plan1.Range("b17") And SENHA.Text = Plan1.Range("c17") Or _
USUARIO.Text = Plan1.Range("b18") And SENHA.Text = Plan1.Range("c18") Then
MsgBox "Bem vindo Hiperlink Via Sul"
Application.Visible = True
Unload HIPERLINK_VIA_SUL
Else
MsgBox "Senha incorreta entrar em contato com a Secretaria Técnica", vbCritical, "Alerta"
End If
End Sub
Cross-Post
Access spreadsheet specifies the log
Thank you!!!
Bookmarks