Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

excel file protection

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
Braveheartli
Asked:
Braveheartli
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Dave BrettVice President - Business EvaluationCommented:
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
 
BraveheartliMarketingAuthor Commented:
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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now