This is really a two fold question.

First, I have a macro that forces a custom header/footer to a page in one
file. Is it possible for me to export this to .xla, and then have it
autoload into other files?

Basically I do not want to have to manually put this code into the vba of
each file. Is my only option a dll?