1. create a log sheet called "open log"
2. put the following macro in the ThisWorkbook code area.

(the Save is needed to trap opens w/o saves)

Private Sub Workbook_Open()
Sheets("open log").Activate
Dim n As Long
n = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(n, 1).Value = Now
ActiveWorkbook.Save
End Sub

--
Gary''s Student - gsnu200739


"Judy" wrote:

I have a Shared file so that I can see who made what changes when, but I
would also like to track when the file has been opened, but no changes made.
Is this possible?

Thanks so much!