Passwords or ???

Pericic

Board Regular
Joined
Nov 11, 2005
Messages
204
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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
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.
Code:
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

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,986
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

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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

Board Regular
Joined
Nov 11, 2005
Messages
204
Thank You all so very much for your wonderful input and precious time
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top