Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date last edited
I would like to enter a field into the footer of an Excel document that
automatically displays the date and time the document was last edited. This is possible in Word and Visio, but I can't find a way to do it in Excel. Is it possible? |
#2
|
|||
|
|||
Private Sub Workbook_BeforePrint(Cacel As Boolean)
With ActiveWorkbook .ActiveSheet.PageSetup.LeftHFooter = "Last saved on: " & _ Format(.BuiltinDocumentPropert*ies("Last Save Time"), _ "dd mmm yyyy") End With End Sub goes in the ThisWorkbook code module. -- HTH Bob Phillips "Mike Sharp" <Mike wrote in message ... I would like to enter a field into the footer of an Excel document that automatically displays the date and time the document was last edited. This is possible in Word and Visio, but I can't find a way to do it in Excel. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Math Problem | Excel Worksheet Functions | |||
date and time | New Users to Excel | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |