View Full Version : Excel file open by specific ID number
Stiepanus
08-13-2018, 07:09 AM
Hello everyone,
Every month i prepare an exel file which i have to send to many recipents. The File containins sensitive data and i have to divide it into several different parts.
Is there a technical possibility to show the data only of person who oppened the file (by user id)?
Thank you in advance for your help :)
fb7894
08-13-2018, 02:12 PM
Not sure I understand. What if the person you email the file to forwards the email to Person#3. Person#3 opens the file and would be able to see the data?
Stiepanus
08-14-2018, 01:07 AM
Ok, now i see that iwrote this a little bit incomprehensibly J
From the beginning...
Every employee in ourcompany logs into the computer using their ID number.
My task is to make areport that I send to superiors and directors. Now I need to divide the fileinto about 30 separate files so that the data of employees of other superiorsdon’t go to them.
Is there a technical possibilityto send one file to everyone and the particular manager could see only the dataof his employees?
Example below:
Employe
Supervisor ID
Director ID
Number of absence days
Last name
First name
Smith
John
A2212
A0932
4
1
Jones
David
A2212
A0932
8
Johnson
Michael
A2212
A0932
10
Lee
Chris
A2212
A0932
27
Brown
Mike
A2212
A0932
56
Williams
Mark
A2212
A0932
29
Rodriguez
Paul
A2212
A0932
6
Garcia
Daniel
A2212
A0932
4
Gonzalez
James
A2212
A0932
4
Lopez
Maria
A4544
A0932
18
2
Lee
Paul
A4544
A0932
33
Brown
Daniel
A4544
A0932
8
Williams
James
A4544
A0932
4
Smith
Maria
A9893
A0045
20
3
Jones
Michael
A9893
A0045
7
Gonzalez
Chris
A9893
A0045
22
Lopez
Mike
A9893
A0045
8
Lee
John
A9893
A0045
17
Brown
David
A9893
A0045
8
Williams
Paul
A2954
A0045
20
4
Johnson
Michael
A3376
A0045
23
5
Gonzalez
John
A3376
A0045
11
In this case I have todivide the file into 5 parts.
Thanks in advance for your help
fb7894
08-14-2018, 07:24 AM
This is possible. But keep in mind, this is NOT what Excel is good at. You can write a macro to hide/unhide sheets based on a person's id. But if a person has VBA skills and Google, they would likely be able to hack it open. My advice.... if you don't want a person to see the data, do not send it to them.
Instead, maybe write a macro that creates 30 different workbooks based on what you want/don't want each person to see??
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.