| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Footnote with date & time last printed
How do I add a footnote to insert the date and time the spreadsheet was last
printed? |
|
#2
|
|||
|
|||
|
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? |
|
#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] "Savvy" wrote: How do I add a footnote to insert the date and time the spreadsheet was last printed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| date & time | Excel Discussion (Misc queries) | |||
| Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Linear Mode
