Passwords or ???

[Pericic]

I have a workbook with a MAIN sheet and 30 other sheets (1 for each employee)

The employee sheets have data which I want ONLY the employee involved to see....no one else....

The MAIN sheet has the names of all employees

What would be the best way to do the following:

Have an emloyee click on their name and see only their sheet????
(passwords, macros, etc)

Thanks to all
Romeo

 

[Datsmart]

You can use several means to identify your users. User of the below code suggestions depends if they log on to their own machines or have setup a username in Microsoft office.

Sub foo()
    Dim CurrentUser As String
    '   PC Login
        CurrentUser = Environ("UserName")
            MsgBox CurrentUser
        '   Microsoft Office Name
        CurrentUser = Application.UserName
            MsgBox CurrentUser
        '   PC Name
        CurrentUser = Environ("ComputerName")
            MsgBox CurrentUser
End Sub

 

[Oaktree]

Romeo:

If this is sensitive data, you really should NOT use one file for all employees, as Excel's "security" measures are really more nuisances than actual security (simple Google searches produce results for how to hack Excel passwords, etc.).

You're better off using a unique file for each employee.

 

[DominicB]

Good evening Pericic

I have a workbook template you are welcome to use. You as admin set up the usernames and passwords of those involved and assign which sheets they can see. When the user opens the workbook they have to enter a username and password, and when entered correctly the tabs they have access to are revealed. You as administrator can access any tabs. Full instructions are included.

If you feel you can make use of this, send me an e-mail, or PM me your e-mail address.

HTH

DominicB

 

[Pericic]

Thank You all so very much for your wonderful input and precious time