ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make all worksheets pull from the same tray (https://www.excelbanter.com/excel-discussion-misc-queries/159135-how-make-all-worksheets-pull-same-tray.html)

Lynn

How to make all worksheets pull from the same tray
 
How can I make all worksheets pull from the same trays without opening going
to each individual worksheet --File -- Page Setup -- click on "Options"
button?
Then on the printer select the Paper Source which we want Tray 2.

The only way I have found to change the paper tray setting for each
worksheet is have do the steps about to each worksheet. Other wise only the
worksheet that I have specified to print Tray 2 will print to Tray the others
will default to Auto (which is LCT).

I have tried right clicking on the worksheet that has the settings I want
then choosing "Select All" then apply these settings to the rest of the
worksheets but that does not work. I even tried making acros but that did
not work either.

Any help you can give would be much appreciated.


All times are GMT +1. The time now is 01:24 PM.

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