Automatic Footers

%3CLINGO-SUB%20id%3D%22lingo-sub-2242728%22%20slang%3D%22en-US%22%3EAutomatic%20Footers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2242728%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20there%20is%20a%20way%20to%20change%20settings%20in%20excel%20to%20include%20an%20automatic%20footer%20with%20the%20date%20and%20time%20the%20excel%20file%20was%20created%2Fedited.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20insights%20would%20be%20much%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2242728%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! 

 

I am wondering if there is a way to change settings in excel to include an automatic footer with the date and time the excel file was created/edited. 

 

Any insights would be much appreciated. 

 

Thank you!

2 Replies

Hi @mjones237 

 

Click Print >> Page Setup >>>Header/Footer >>> Then click Date & Time

tauqeeracma_0-1617034262897.png

Thanks

@mjones237 

Formatting and VBA codes for headers and footers

The following special formatting and Visual Basic for Applications (VBA) codes can be included as a part of the header and footer properties (LeftHeader, CenterHeader, RightHeader, LeftFooter, CenterFooter, and RightFooter).

Example

The following code shows how formatting and VBA codes can be used to modify the header information and appearance.

 

Sub Date_Time() 
 ActiveSheet.PageSetup.CenterHeader = "&D &B&ITime:&I&B&T" 
End Sub

 

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

 

Hope I was able to help you with this info.

 

 

Nikolino

I know I don't know anything (Socrates)