Hey Dave.. thanks for the reply.. i got it to do that... its the part where I
need it to record the settings I set for the printer that it does not do.

Any ideas?

"davesexcel" wrote:


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