default printer setup for individual worksheet only

A

Al

Is it possible to set different default printer settings
for individual workbooks? ie- I have one workbook that
contains twelve worksheets...I want these to print by
default on 8 1/2 x 14 legal paper. All other workbooks, I
want to print standard 8 1/2 x 11. I would like to be able
to do this without having to open file/page setup/etc.
each time.
Thanks,
Al
 
G

Gord Dibben

Al

The page setup is saved with the workbook.

For that particulae workbook you should be able to setup as you wish and save
it.

Other workbooks would take the default settings which are set with the Printer
Settings through Start>Settings>Printer and Faxes>Properties(of your printer).

Gord Dibben Excel MVP
 
Top