ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I can I set up Excel to print all sheets of a workbook as a defau. (https://www.excelbanter.com/excel-discussion-misc-queries/3896-i-can-i-set-up-excel-print-all-sheets-workbook-defau.html)

Homebody

I can I set up Excel to print all sheets of a workbook as a defau.
 
I send a lot of excel workbooks as email attachments in Outlook. The
recipient of the attachementss prints all of the attachements at once by
selecting the letter and pressing "File", "print" , and checking print all
attachemtns radial button on the resulting Outlook dropdown menu. When this
is done only the active sheets prints.

Excel 2003 and Outlook 2003

Trevor Shuttleworth

One way would be to group the sheets before you save and close the
workbook(s). When they are opened and printed all the sheets will be
printed.

Regards

Trevor


"Homebody" wrote in message
...
I send a lot of excel workbooks as email attachments in Outlook. The
recipient of the attachementss prints all of the attachements at once by
selecting the letter and pressing "File", "print" , and checking print all
attachemtns radial button on the resulting Outlook dropdown menu. When
this
is done only the active sheets prints.

Excel 2003 and Outlook 2003





All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com