Nav
11-28-2008, 03:51 PM
Hi
We have several files with 40+ worksheets in each, they each have their own headers and footers. However the print areas are different on each sheet, this causes the Font size to resize as the print area is larger/smaller than normal. Is there some macro that can be run that will resize the font so that it is the same on when printed on all pages.
I have been told that you should multiply the required font size by a foctor of 100 divided by the zoom amount. Does anyone know how to do this and that can be applied to exisiting headers and footers?
Any help appreciated.
Regards,
Nav
We have several files with 40+ worksheets in each, they each have their own headers and footers. However the print areas are different on each sheet, this causes the Font size to resize as the print area is larger/smaller than normal. Is there some macro that can be run that will resize the font so that it is the same on when printed on all pages.
I have been told that you should multiply the required font size by a foctor of 100 divided by the zoom amount. Does anyone know how to do this and that can be applied to exisiting headers and footers?
Any help appreciated.
Regards,
Nav