EXCEL FOOTER: Last Modified Date

[Steven Cooper]

Within Excel 2000 and Excel XP, is there a way to insert into a custom
footer and auto update the files last modified date?

Thank you,
-sdc-

 

[Bob Phillips]

Steven,

Private Sub Workbook_BeforePrint(Cacel As Boolean)
With ActiveWorkbook
.ActiveSheet.PageSetup.LeftHeader = "Last saved on: " & _
Format(.BuiltinDocumentProperties("Last Save Time"), "dd mmm
yyyy")
End With
End Sub

goes in the ThisWorkbook code module.

Watch the wrap-around on the Format line


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)