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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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
8,053
Office Version
  1. 365
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,128
Messages
5,857,533
Members
431,884
Latest member
Gcmoore63

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top