Creating a macro to print the date a document was last saved.

  • Thread starter Thread starter Judi
  • Start date Start date
J

Judi

Good morning!

I am looking to add a macro to a workbook that will automatically print the
date last saved (in the bottom right corner, I think).

Can you help?

THANK YOU!

~judi
 
Hi,

Try adding

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader =
ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save Time")
End Sub

If this helps, please click the Yes button,

Cheers,
Shane Devenshire
 
Back
Top