last saved by
 

In Word 2003 theres an useful possibility to add "last saved by" in the
footer. I cannot see that function is incorporated in Excel, or am I wrong on
this?

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


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bjørn Talmo" <Bjrn wrote in message
...
In Word 2003 theres an useful possibility to add "last saved by" in the
footer. I cannot see that function is incorporated in Excel, or am I wrong
on
this?