Track who opened Excel Sheet - Access Logs

It very likely that multiple people would be working on the same excel sheet for updating the data. For example you want to gather some information from your employees like their address, then you can create an excel sheet and save it on a shared location. Your employees can open the file from that location and fill their details.

There might be a need where you might also be interested in knowing who has saved the excel sheet. This way you can track who has not filled their details!!

You can create a Macro in excel to enable user logs. Whenever a person saves any data in the sheet, his/her system username and time of saving can be stored. Follow the below steps.

1. Create a Sheet named "Log" with the following format.

Timestamp	Username

2. Copy the following code in the Workbook_Open Event

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 _
    = Environ("UserName")
End Sub

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.

Simple and neat trick!!