We have a shared drive on our network and we make a lot of daily reports, I would like to know who opened the reports and the time. I made a search on Google and I came to these steps but since i'm not more than just a beginner whe it came to Excel or Access I need someone to explain it step by step.
here is the steps:
If your Excel Sheets are stored on a shared location and you also want to tracked who opened that Excel and Saved it then use the following steps.
1. Create a Sheet named "Log" with the following format.
2. Copy the following code in the Workbook_Open Event ......... (where can I find that ?)
Private Sub Workbook_Open()
Worksheets("Log").Range("A65536").End(xlUp).Offset(1, 0).Value _
= Format(Now(), "mm-dd-yy HH MM AMPM")
Worksheets("Log").Range("B65536").End(xlUp).Offset(1, 0).Value _
3. Next whenever anyone opens the Excel Sheet his name will be stored in the Sheet "Log". You can hide this sheet so that others cannot see and modify it. ............... (where to save this log file)