You could use the workbook open event:
![]()
Private Sub Workbook_Open() Dim mySecretLog As String, FF As Integer mySecretLog = "X:\Secret\FileLog.LOG" FF = FreeFile Open mySecretLog For Output As #FF Print #FF, Environ("USERNAME") & " opened workbook: " & Now Close #FF End Sub
Bookmarks