View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default set a permanent paper size

Can't you install a printer driver for the network printer on your
machine, and have that selected?

Hope this helps.

Pete

On Sep 11, 2:44*pm, mooresk257
wrote:
I have a series of charts as separate tabs in a workbook. I would like to
permanently set the paper size to 11x17. The problem is that my default
printer only prints 8-1/2 x 11, and I use a network printer for 11x17.

When I re-open the file, it automatically resets all the paper sizes to
8-1/2 x 11.

This is a huge problem because when other people open the file, it resets
the page layout to portrait if that is their default printer setup. This
moves all of the drawing items around and screws up the charts every time..

Is there some way to permanently fix the paper size so that it does not
change for any reason - ever - regardless of printer selection?