File Access History

[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.

 

[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"

 

[scott]

Interesting.
Does it work if the user disables macros?

 

[Dave Peterson]

No. Macros won't run if macros are disabled.

Interesting.
Does it work if the user disables macros?