Every google hit for applying the same header says to highlight all sheets and set a header. How can I ensure that new sheets I add also get the same header, without alway
As a first attempt i would use this event:
you would have to add this macro to your Workbook, not to a Worksheet, not as a Module or Class.
Anotherway might be the use of an add-in, designed for this - this would be for the purpose of having this behaviour in every workbook.
Here is VBA code to copy the header and footer from the first sheet to new sheet. Insert this into
Adjust the 4th line, where it reads
If you want to run it manually, change the first line to
It will then show up as a runnable macro (Alt+F8), named