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 ...

You can print a Selection (which will typically be one cell, unless you intentionally selected a range before opening the Print dialog), Active Sheets, or Entire Workbook.