View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sophia Sophia is offline
external usenet poster
 
Posts: 3
Default 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