Solved

excel file protection

Posted on 2011-03-14
3
298 Views
Last Modified: 2012-05-11
is there a way to understand who copied my excel file in the company or send it as a email, or save the file as a diffrent name in his directory?
in the company every user has a username, so that I think i can use it.
Can I use a macro for this?
0
Comment
Question by:Braveheartli
3 Comments
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 150 total points
ID: 35126779
Hello,

Inspecting an Excel 2003 (and earlier) file with a Hex Editor, you can see who was the last person to open it (even if they did not change and save it), but as far as I know there is no way of telling whether a file was saved it with a different name or whether it was emailed.

cheers, teylyn
0
 
LVL 50

Accepted Solution

by:
Dave Brett earned 350 total points
ID: 35126866
Not in a practial manner

On file access you are really looking for a network security utility, or a program like FileMon

Vbscript provides WMI events that can monitor activity, this can be used in VBA. Ivan Moala provides a masterful example here
http://www.dailydoseofexcel.com/archives/2006/07/07/monitor-directory/#comments

I have written code that emailed me via CDO every time someone opened a certain file (not really appropriate here as it avoids the Outlook security message)

Your best defence is to host the file in a trusted location, and to use passwords

Cheers

Dave
0
 
LVL 1

Author Closing Comment

by:Braveheartli
ID: 35137035
thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generating a graph via Excel 3 26
Problem to open text file 11 70
Formula or Macro to determine variance 17 75
IF ELSE Statement in Excel Macro VBA 16 34
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now