Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help... File Not Saved | Excel Discussion (Misc queries) | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
I'm getting files saved with names like 48A52100 with no .xls f. | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel |