Print Entire Workbook

  • Thread starter Thread starter Charles Phillips
  • Start date Start date
C

Charles Phillips

Hello,
I have an MS-Excel 97 workbook, I want to printout.
Each time I try to print the entire workbook (I select print entire
workbook), only 1 sheet prints.
Can/will someone tell what I am doing wrong???

Charles L. Phillips
 
Charles, not certain why it is not working. However, you can try selecting
all sheets (right click on a sheet and select that option) and then clicking
on the print button.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Hi Charles

So long as the other sheets have data this should work. One thing to
check is that the Print Area on the other sheets has not been set to a
blank range. Probaly best to Clear the Print area on each sheet.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top