ExcelBanter

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

Sophia[_3_]

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. The read-only permission is intended. Any ideas on what I need to do with the code? Thank you

Private Sub Workbook_Open(

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

End Su




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

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