ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Headers and Footers (https://www.excelbanter.com/excel-discussion-misc-queries/87083-excel-headers-footers.html)

Amy

Excel Headers and Footers
 
How do I create a footer that shows when my Excel document was last updated?

Gazeta

Excel Headers and Footers
 

Użytkownik "Amy" napisał w wiadomości
...
How do I create a footer that shows when my Excel document was last

updated?

try
With ActiveSheet.PageSetup
.CenterHeader = ActiveWorkbook.BuiltinDocumentProperties("Last Save
Time")
End With
mcg





Hanr3

Excel Headers and Footers
 
View
Header/Footer
Custom Footer
Select the appropriate button.

--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Gazeta" wrote:


UÂżytkownik "Amy" napisaÂł w wiadomoÂści
...
How do I create a footer that shows when my Excel document was last

updated?

try
With ActiveSheet.PageSetup
.CenterHeader = ActiveWorkbook.BuiltinDocumentProperties("Last Save
Time")
End With
mcg







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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com