Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

excel file protection

Posted on 2011-03-14
3
Medium Priority
?
305 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 (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 600 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 1400 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

886 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