How do I add the last modified date to the footer in Excel?

  • Thread starter Thread starter JagodaW
  • Start date Start date
J

JagodaW

In Word, you can enter: Document last changed: { SAVEDATE \@ "d MMMM yyyy
'at' HHmm 'hours' " } to display the last saved date in the footer. Can you
do this in Excel?
 
You need to use a macro to do this. If you are new to macros set the Security
level to low/medium in (Tools|Macro|Security). From workbook launch VBE using
short-key Alt+F11. On the left treeview double click 'This Workbook' and
paste the code to the code panel.

Return back to workbook and try print preview.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.RightFooter = _
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Sub

If this post helps click Yes
 
Back
Top