ExcelBanter - Tracking who accesses a spreadsheet

add a new page called log then use this macro

Sub auto_open()
Application.ScreenUpdating = False
Sheets("log").Select
Rows("3:3").Select
Selection.Insert Shift:=xlDown
Sheets("log").Range("C3") = Application.UserName
Sheets("log").Range("a3") = Now()
Sheets("log").Range("b3") = Now()
Sheets("log").Range("d3") = "Open Workbook"
Rows("3:3").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("A3").Select
Selection.NumberFormat = "dd-mmm-yy"
Range("B3").Select
Selection.NumberFormat = "h:mm"
Application.ScreenUpdating = True
End Sub

of course this not save the log file if the workbook is closed without
saving it, but you could had a autosave line to facilitate this

"juamig" wrote:

Is there any type of add-in for excel that would track and provide info on
who accesses a spreadsheet that is located in a shared folder? If not is
there any suggestion on how to get this info?