AFIK, you just have to leave enough margin on your print area to allow for
the headers and/or footers. That is controlled in your page set up, which
can be done manually or by code. Check the help files for details.

"Nav" wrote:

Hello

I am using Office 2003, and have headers and footers on some 40 sheets (not
the 1st sheet and not the last sheet) that are all the same (and some 40
files that each have their own headers/footers). 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.

Please note that letter heads are not an option, and the footer page x of x
would still need to be fixed in size.

Any help appreciated.

Thank you and regards,
Nav