Hi,
i have a spread sheet with over 20 worktabs and needs to show the date, time and author every time each worktab is modified in anyway.
I am currently using the code shown below in each worktab but this is only showing date, time etc on one tab at a time even if multiple tabs have been modified.
can you advise on this please?
i have a spread sheet with over 20 worktabs and needs to show the date, time and author every time each worktab is modified in anyway.
I am currently using the code shown below in each worktab but this is only showing date, time etc on one tab at a time even if multiple tabs have been modified.
Code:
Private Sub Workbook_Open()
Dim last_auth As String
Dim last_save As String
last_auth = ThisWorkbook.BuiltinDocumentProperties("Last Author")
last_save = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
ThisWorkbook.BuiltinDocumentProperties("Last Author") = last_auth
ThisWorkbook.BuiltinDocumentProperties("Last Save Time") = last_save
Range("E2") = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
Range("E3") = ThisWorkbook.BuiltinDocumentProperties("Last Author")
End Sub
can you advise on this please?
Last edited by a moderator: