Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need some code for header/ footer, another case of "last saved
Try this hspence
http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "hspence" wrote in message ... Hi Jim, sorry, this doesn't seem to be working for me, but I have not programmed much, so perhaps I am not changing the sheet reference correctly?? I'd like this to run on all sheets in the workbook. "Jim Thomlinson" wrote: Give this a try... Just change the sheet reference... With ThisWorkbook Sheets("Sheet1").PageSetup.LeftFooter = "Last modified by " & _ .BuiltinDocumentProperties("Last Author") & " on " & _ .BuiltinDocumentProperties("Last Save Time") End With -- HTH... Jim Thomlinson "hspence" wrote: I've seen lots of examples on here that does one or the other, but can't find a piece of code that does both. In my footer, I want to display the name of the person who last modified the file, and the date & time it was saved. I also want the font size to be 20. In plain english, it would read: Last Modified by [last author] on dd-mmm-yyyy hh:mm:ss If you can steer me to such an example, or write it here for me, I would very much appreciate it. THanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put special character "&" in Excel Header / Footer ? | Excel Discussion (Misc queries) | |||
How to use "&" character in header or footer; won't print | Excel Discussion (Misc queries) | |||
Adding "last saved date" to header | Excel Discussion (Misc queries) | |||
Show where worksheet is saved in the header/footer | Excel Discussion (Misc queries) | |||
Formula for Last Saved on outside of Header/Footer | Excel Worksheet Functions |