You can get the code by turning on the macro recorder and making the change
to one sheet.

this will record all settings, even though you only change one. You don't
need to do all settings.

Select the subset you need and put this in the BeforePrint Event of the
workbook

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"indigo " wrote in message
...
I have a workbook with about 20 tabs and would like them all to print
out one page tall, one page wide on 11 x 17 paper. I can highlight all
tabs and change the setting to 11 x 17, but if I access the file on
another computer with a different printer, it resets the
configuration.

Is there a way to push a command button that changes the print size to
11 x 17 and prints the page on the default printer? Need help with the
code!


---
Message posted from http://www.ExcelForum.com/