See who accessed file from public drive

[ryokahn]

I have an excel file with macros and formulas and I was wondering if there was a way to see which computer or user accessed the program. The problem is there are people in the office, let's call them "haters", That are deleting stuff from the file. I know i can protect the excel file, but my boss wants everyone to have all access to the entire file without passwords. Is there a way to see who logged on the file? Either through a macro or through another tab in which the cells are locked by passwords? Just wondering if this was possible at all, didn't know if it was like a big brother kinda thing or what. Thank you for your time with this matter

 

[Trevor G]

You can do something like this. Open the workbook and use Alt + F11 then in the VBA screen Double Click on the left where it says ThisWorkbook, this will give you a empty page, then at the Top you can click the first drop down which says General and change to Workbook, this will give you the following: (Copy the workbook first or create a new workbook to test it)

Private Sub Workbook_Open()
End Sub

What you can do next is add some code so that you can record who has been in the workbook and what time in

Add a sheet to the workbook and name it something like Log. In the sheet place in 2 Headings, User and Date

then add this code in the workbook on open event.

Private Sub Workbook_Open()
Sheets("Log").Activate
Range("A2").Activate
Do Until ActiveCell.Value = ""
ActiveCell.Offset(1, 0).Select
Loop
ActiveCell = Environ("UserName")
ActiveCell.Offset(0, 1) = Now()
End Sub

 

[ryokahn]

Thank you for the help. I made this excel program and just wanted to see if it's being used. Everytime I ask, they say no, but something is always changed in the program. I know it's probably spying, but eh, at least I can now tell who's using it. Some of these take a lot of work (i'm sure you know), and I just want to make sure people are using it. Once again Thank you for your help.

Matt