Access spreadsheet specifies the log

[marreco]

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.

If USUARIO.Text = Plan1.Range("b12") And SENHA.Text = Plan1.Range("c12" Activate.Sheets ("Administrador")

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 (http://www.thecodecage.com/forumz/microsoft-excel-forum/213732-access-spreadsheet-specifies-log.html)

Thank you!!!

[Admin]

Hi,

Please find attached. I created this some years back.

user i: Admin
pwd: pass

[marreco]

Hi.
In his model, a user only has, moreover, the code does not catch the name of the user within the spreadsheet.

I'm not able to adapt.

thank you!

[marreco]

Hi
someone at least direct me to some site that addresses issues with users login on the worksheet?