printing entire workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I change the default on the print dialog box to automatically print
the entire workbook, not just the current worksheet?
 
I don't know about changing the default, but maybe this will get you what
you want.
If your situation is such that you know you will always be printing only the
entire workbook, then you can use a Workbook_BeforePrint event macro to
cancel the print command, automatically setup to print the entire workbook,
and reissue the print command.
If you sometimes want to print something other than the entire workbook, the
same macro can be used with a message box popping up asking if you want to
print the entire workbook, Yes/No. Answer No and the print command will
continue as setup. If you answer Yes, the same procedure as above ensues.
Post back if you need more. HTH Otto
 
You must log in or register to reply here.

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

Workbook Printing Problem 1
printing preference 2
Print Entire Workbook acting strangely 1
Excel is now printing all the entire workbook. 6
Set the print order of worksheets when printing entire workbook 2
Printing multiple worksheets in a workbook 3
Duplex Printing of Workbook with multiple worksheets 2
Printing Worksheet/Workbook 2

Back
Top