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?
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 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks