Thanks but I've tried it.
Excel still defaults to the last printer I used.

"kev_06" wrote:


Application.Dialogs(xlDialogPrinterSetup).Show


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=556418