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)

Hi mjones237 

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

Thanks