last saved by

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I add the last modified date to the footer in Excel? 1
Excel Unique last page footer 1
Last Saved Date in Footer (right aligned) 8
Date last modified - for entire workbook 3
Including document property values in Excel headers 2
Excel 2003 save as .XLSX 10
Custom information in Excel footer 8
LAST SAVED BY 2

Back
Top