Solved

excel file protection

Posted on 2011-03-14
3
302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

626 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