Hello folks,

I created two buttons in my excel sheet. If I click on button1, it is
supposed to print the sheet on pdf file. If click on button2, it is
supposed to send the print job to the printer.

I am using the following command in my script:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

which sends the print job to the default printer.

Do you know if there is a way to define the printer I want to use for
the print job in the script?

Umit


--
umitakkaya
------------------------------------------------------------------------
umitakkaya's Profile: http://www.excelforum.com/member.php...o&userid=33955
View this thread: http://www.excelforum.com/showthread...hreadid=538467