![]() |
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