Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Word, you can enter: Document last changed: { SAVEDATE \@ "d MMMM yyyy
'at' HHmm 'hours' " } to display the last saved date in the footer. Can you do this in Excel? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You need to use a macro to do this. If you are new to macros set the Security
level to low/medium in (Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11. On the left treeview double click 'This Workbook' and paste the code to the code panel. Return back to workbook and try print preview. Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.RightFooter = _ ThisWorkbook.BuiltinDocumentProperties("Last Save Time") End Sub If this post helps click Yes --------------- Jacob Skaria "JagodaW" wrote: In Word, you can enter: Document last changed: { SAVEDATE \@ "d MMMM yyyy 'at' HHmm 'hours' " } to display the last saved date in the footer. Can you do this in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Including the modified date in the footer | Excel Discussion (Misc queries) | |||
How do I insert the date modified in a spreadsheet footer? | Excel Discussion (Misc queries) | |||
date modified in footer | Excel Discussion (Misc queries) | |||
How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
EXCEL - is there a way to insert "date modified" into | Excel Worksheet Functions |