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