Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
printing entire workbook
How do I change the default on the print dialog box to automatically print
the entire workbook, not just the current worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
printing entire workbook
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 "loralei" wrote in message ... How do I change the default on the print dialog box to automatically print the entire workbook, not just the current worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to convert an entire Excel workbook to a pdf file? | Excel Discussion (Misc queries) | |||
VLookup function to search an entire workbook | Excel Worksheet Functions | |||
Printing Entire Contents of Cell | Excel Discussion (Misc queries) | |||
printing workbook -landscap in to portrait format in Excel | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) |