Guys, I am trying to find out a way to identify who modifies my excel file in office? I am using the code mentioned below but it's only giving me "Administrator" as the name who updated excel file instead of real person name.
Private Sub Workbook_Open()
ThisWorkbook.Windows(1).Caption = ThisWorkbook.Windows(1).Caption & _
" Last Updated By: " & _
ThisWorkbook.BuiltinDocumentProperties("Last Author") & _
" on " & _
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")