before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326