Footnote with date & time last printed
 

How do I add a footnote to insert the date and time the spreadsheet was last
printed?

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?

You could also go into the Footer and view the custom footer. There you can
set the file to print the time and date for when the spreadsheet was printed
something like: Printed at &[Time] on &[Date]

"Savvy" wrote:

How do I add a footnote to insert the date and time the spreadsheet was last
printed?