How do I add a footnote to insert the date and time the spreadsheet was last printed?
S Savvy Sep 20, 2005 #1 How do I add a footnote to insert the date and time the spreadsheet was last printed?
B Bob Phillips Sep 20, 2005 #2 ThisWorkbook.Worksheets("Sheet1").PageSetup.LeftFooter = _ Format(ThisWorkbook.BuiltinDocumentProperties _ ("last save time"), "dd mmm yyyy hh:mm:ss")
ThisWorkbook.Worksheets("Sheet1").PageSetup.LeftFooter = _ Format(ThisWorkbook.BuiltinDocumentProperties _ ("last save time"), "dd mmm yyyy hh:mm:ss")
E eric_rs1 Oct 3, 2005 #3 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]
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]
