Pre-set Footers (or Headers) in Excel

[johns88]

When I print Excel worksheets, I like to print in the footer the date & time, the page number of number of pages, and the file name & worksheet name.
Currently, I have to manually set this in every worksheet I create or open.
Any ideas how I could programmically set these for all worksheets in an Excel file.
Help would be greatly appreciated.
Thanks.
John

 

[BMeek]

You can create yourself a template of a blank Excel workbook with your customized headers and footers in place. This will also work on margins if you have to make any adjustments to themn before printing as well. Bryan Meek
bmeek@adelphia.net

 

[vbMax]

You can try the following VBA code...

With ActiveSheet.PageSetup
.LeftFooter = "&""Arial,Regular," & "Place text here"
End With

- vbMax