ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tracking Workbook Usage (https://www.excelbanter.com/excel-programming/300982-tracking-workbook-usage.html)

Sophia

Tracking Workbook Usage
 
I would like to track who opens a certain excel workbook. The macro below works great but only for those who have read & write permissions. It doesn't track users that have read-only permissions. Any ideas on the code? The uses must have read only permission.

Private Sub Workbook_Open()

Open ThisWorkbook.Path & "\TrackUsage.log" For Append As #1
Print #1, Application.UserName, Now, "Opened"
Close #1

End Sub


All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com