I have some workbooks that contain multiple worksheets. Is it possible
to collectively change the size of the page that they will print out on
once i select, File -- Print -- Entire Workbook -- OK.

Normally what happens is that I have to do page setup of each
individual worksheet before I can get the entire work book to print on
the desired page size. If anyone out there can help make this process
simpler (eg a single click) then please let me know.


Thanks.