Hello

I am using Office 2003, and have headers and footers on some 40 sheets that
are all the same. However as each of these sheets is set to print on page 1
of 1 the print area is different for each one.

As the print area is different the size of the headers and footers keep
changing. Is there a way to fix the font and size etc.. so regardless of the
print area size the headers and footers all remain the same size, either via
VBA or using the settings in Excel.

Any help appreciated.

Thank you and regards,
Nav