#1   Report Post  
Bjørn Talmo
 
Posts: n/a
Default 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?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help... File Not Saved SteveHoot Excel Discussion (Misc queries) 0 January 5th 05 10:45 AM
How do I stop today() from updating date on saved spreadsheets? lionmark Excel Discussion (Misc queries) 2 January 4th 05 01:03 AM
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . DUFFER8MCD Excel Discussion (Misc queries) 1 December 23rd 04 11:32 PM
I'm getting files saved with names like 48A52100 with no .xls f. KELTON Excel Discussion (Misc queries) 2 December 21st 04 04:01 PM
Linking to Worksheets on Excel -Saved Web Page Lawman Links and Linking in Excel 3 December 8th 04 08:13 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"