View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Annabelle

With code you can do this
Copy this event in the Thisworkbook module
It will automatic run when you save the file

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
Sheets("Sheet1").Range("A2").Value = ThisWorkbook.BuiltinDocumentProperties("Author")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Annabelle" wrote in message oups.com...
Although found under the Properties section, is it possible to display
on the worksheet the Last Saved By date and Last Saved By user?