Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date function
Hello everyone,
I need help with the following problem: how would I invoke the function I listed below in order for the LMD (Last Modified Date) to display in the footer? Function LMD() LMD = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") End Function Thank you |
#2
|
|||
|
|||
You would need a macro
Sub LMD() On Error Resume Next ActiveSheet.PageSetup.RightFooter = _ ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") End Sub or automatically http://www.rondebruin.nl/print.htm#Saved -- Regards, Peo Sjoblom "geza" wrote in message ... Hello everyone, I need help with the following problem: how would I invoke the function I listed below in order for the LMD (Last Modified Date) to display in the footer? Function LMD() LMD = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") End Function Thank you |
#3
|
|||
|
|||
Thank you very much,
Geza. "Peo Sjoblom" wrote: You would need a macro Sub LMD() On Error Resume Next ActiveSheet.PageSetup.RightFooter = _ ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") End Sub or automatically http://www.rondebruin.nl/print.htm#Saved -- Regards, Peo Sjoblom "geza" wrote in message ... Hello everyone, I need help with the following problem: how would I invoke the function I listed below in order for the LMD (Last Modified Date) to display in the footer? Function LMD() LMD = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") End Function Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
If Function with Date | Excel Worksheet Functions | |||
Date Function | Excel Worksheet Functions | |||
Excel :Save date function | Excel Worksheet Functions | |||
Formula for date function | Excel Worksheet Functions |