View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sophia[_3_] Sophia[_3_] 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 what I need to do? Thank you

Private Sub Workbook_Open(

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

End Su