File Access History

  • Thread starter File Access History
  • Start date
F

File Access History

Is there anything in Excel that will show a history of who accessed,
modified, and/or saved an Excel workbook other than what's in the file
properties dialog box?

Thanks in advance. :)
 
G

Guest

hi,
Private Sub Workbook_Open()
Sheets("Formula").Range("IQ2").End(xlDown).Offset(1,
0).FormulaR1C1 = Now()
Sheets("Formula").Range("IQ2").End(xlDown).Offset(0,
1).FormulaR1C1 = Application.UserName
End Sub
we use this in some of our files to record who opened the
file and when.
(sssshhhhh. no one is suppost to know...)
you might be able to add the same code to the before save
event. but i would add code to each module to tell the
difference. like for the open event
Sheets("Formula").Range("IQ2").End(xlDown).Offset(0,
2).FormulaR1C1 = "WB Open"
and for the before save event...
Sheets("Formula").Range("IQ2").End(xlDown).Offset(0,
2).FormulaR1C1 = "save"
 
Top