Hey guys -I need to print a few workbooks to scale (say 75%,) and not just a page - all the pages in each workbook. The thing is is that I need to automate this with WinRunner and these workbooks ...

You can set the print area of an Excel spreadsheet using the Print Area button to print only a selected area of a spreadsheet.

How to create color scales in Excel If you prefer, you can also use color scales rather than data bars.