How do I print complete workbook

S

Sharon

I have a file which consists of several pages. I want to print the whole
workbook with one click.
 
G

Gord Dibben

Record a macro whilst going to File>Print>Entire Workbook.

Assign that macro to a button and click once.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i print two workbook sheets onto one page side by side? 1
how do i remove extra pages from my speadsheet? 1
Print Error Message: Print titles must be contiguous and complete 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2003 - Cannot print entire workbook in PDF 1
Printing 1
print on both sides problem 2
Continuous page numbering when printing whole book 2

Top