Excel buttons to print out on pdf file and printer!!
 

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. :mad:

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

Umit :cool:


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