I have this which is in a bit of code activated by a button.

Charts("Overall Days By Period").PrintOut

but this just prints straight out to whatever printer is currentl
selected. Is there a way to change this so that it brings up th
dialog box which asks things like which printer, how many copies etc

--
neowo
-----------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...nfo&userid=594
View this thread: http://www.excelforum.com/showthread.php?threadid=27202