Have a look at:
http://exceltips.vitalnews.com/Pages...n_a_Macro.html
This workaround (and other Google hits) suggest defining a series of
printers each with a different tray selected. Then in VBA you select the
appropriate
printer.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"harrybigby" wrote in message
...
How do I change the paper source of an Excel printer using Visual Basic?