customer header & footer

[terzak]

Once I create a customer header or footer is there a way
to save it and have it available from the dropdown for
other workbooks?

 

[Peo Sjoblom]

You can save a workbook as book.xlt and put it in the xlstart folder, that
way all new workbooks will have
that footer/header. Instead of that I personally would probably use VBA and
run a macro when I wanted that,
to get most info for a macro you can record it while you customize the
footer..