ThisWorkbook.Worksheets("Sheet1").PageSetup.LeftFo oter = _
Format(ThisWorkbook.BuiltinDocumentProperties _
("last save time"), "dd mmm yyyy hh:mm:ss")


--
HTH

Bob Phillips

"Savvy" wrote in message
...
How do I add a footnote to insert the date and time the spreadsheet was
last
printed?