software

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?

add a new page called log then use this macroSub auto_open()
Application.ScreenUpdating = False
Sheets(quot;logquot;).Select
Rows(quot;3:3quot;).Select
Selection.Insert Shift:=xlDown
Sheets(quot;logquot;).Range(quot;C3quot;) = Application.UserName
Sheets(quot;logquot;).Range(quot;a3quot;) = Now()
Sheets(quot;logquot;).Range(quot;b3quot;) = Now()
Sheets(quot;logquot;).Range(quot;d3quot;) = quot;Open Workbookquot;
Rows(quot;3:3quot;).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range(quot;A3quot;).Select
Selection.NumberFormat = quot;dd-mmm-yyquot;
Range(quot;B3quot;).Select
Selection.NumberFormat = quot;h:mmquot;
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
quot;juamigquot; wrote:

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