Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Modified Date
i searched the newsgroup for this "last modified date in header", &
the 1st post listed an example......... title: Need some code for header/ footer, another case of "last saved by. http://groups.google.com/group/micro...d4b9aa2fd5198b Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ThisWorkbook.Worksheets wkSht.PageSetup.RightFooter = ("&20Last Saved or Modified by ") & _ (Format(ThisWorkbook.BuiltinDocumentProperties("La st Author"))) & ("&20 on ") & _ (Format(ThisWorkbook.BuiltinDocumentProperties("La st Save Time"))) Next wkSht End Sub watch out for line breaks if you cut & paste this........ hth susan On May 23, 11:01 am, Me wrote: Can I put the last modified time and date into a header in Excel 2003? If so, how would I do that? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to get modified date | Excel Programming | |||
date that a row is modified | Excel Discussion (Misc queries) | |||
modified date | Excel Programming | |||
Modified Date | New Users to Excel | |||
Last Modified Date | Excel Programming |