Date last edited

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

Guest

I would like to enter a field into the footer of an Excel document that
automatically displays the date and time the document was last edited. This
is possible in Word and Visio, but I can't find a way to do it in Excel. Is
it possible?
 
Private Sub Workbook_BeforePrint(Cacel As Boolean)
With ActiveWorkbook
.ActiveSheet.PageSetup.LeftHFooter = "Last saved on: " & _
Format(.BuiltinDocumentPropert­ies("Last Save Time"), _

"dd mmm yyyy")
End With
End Sub


goes in the ThisWorkbook code module.
 
You must log in or register to reply here.

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
How do I enter the date last modified in the footer of an Excel d. 1
Custom information in Excel footer 8
How do I add the file last modified date into an Excel header? 3
Can excel update date when document last changed? 1
How to put save date in the header (or footer) 10
Inserting Auto Text for "Last Printed On" Date 1
Last Saved Date 2

Back
Top