Results 1 to 4 of 4

Thread: Access spreadsheet specifies the log

  1. #1
    Member
    Join Date
    Aug 2012
    Posts
    72
    Rep Power
    13

    Access spreadsheet specifies the log

    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!!!

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Please find attached. I created this some years back.

    user i: Admin
    pwd: pass
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Member
    Join Date
    Aug 2012
    Posts
    72
    Rep Power
    13
    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!

  4. #4
    Member
    Join Date
    Aug 2012
    Posts
    72
    Rep Power
    13
    Hi
    someone at least direct me to some site that addresses issues with users login on the worksheet?

Similar Threads

  1. Inserting time in spreadsheet
    By papabill in forum Excel Help
    Replies: 17
    Last Post: 10-25-2013, 01:34 PM
  2. How to Update Daily Log In Another Sheet
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 6
    Last Post: 04-06-2013, 01:47 PM
  3. Budget Spreadsheet Template
    By rich_cirillo in forum Excel Help
    Replies: 1
    Last Post: 02-12-2013, 10:32 PM
  4. Automate distribution in excel spreadsheet
    By marreco in forum Excel Help
    Replies: 7
    Last Post: 12-27-2012, 10:49 PM
  5. Log In To Email Account Using VBA
    By Excel Fox in forum Download Center
    Replies: 1
    Last Post: 12-14-2012, 11:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •