Question about print scaling and page header/footer

[tempest]

Does anyone know if it's possible to make Excel print headers and
footers in the original scale regardless of the print scaling of the
rest of the worksheets?

I am trying to print out some analysis worksheets and I have set every
worksheet to fit to 1 page wide by 1 page tall when printed. However,
I noticed both headers and footers are also scaled in size when
printed. That doesn't make much sense because headers and footers are
always going to be printed outside of the header/footer margins
regardless of the how the rest of the worksheet scales. I have page
numbers in the footer of each worksheet. Just imagine how weird the
page numbers would look when printed in various font size from less
than 8pt to 12pt.

Any information would be appreciated.
Thanks.

 

[Paul Cundle]

An interesting question. I don't have an answer, other than programmatically
having the header/footer font size changed automatically before a print. So
if, for example, the page is being scaled to 70% then you would increase
your 12pt footer to 17pt to compensate.

I have a rough idea in my head how this would work and will elaborate if
necessary, but hopefully somebody will suggest something better.

Paul C,