ActiveSheet.Printout or Page Setup?
 

Hi all,

I have a workbook that will not print out completely at 100% on legal size paper in using the print
area I want to display. My question is, would it be better to use the page setup to "shrink" the
scaling to a value printable on a full page, or should this be done with VBA. The workbook will be
distributed to several hundred users who have Excel versions ranging from 97 to 2003.

If VBA is the best way, what code would I use?

Thanks in advance for your assistance,

Miki B