| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.  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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print a whole excel file in colour when the default is mo | Excel Discussion (Misc queries) | |||
| Print Excel to MODI Writer? | Excel Discussion (Misc queries) | |||
| Print Excel to Microsoft Document Image File (MDI) | Excel Discussion (Misc queries) | |||
| No printer select in excel | Excel Discussion (Misc queries) | |||
| How do I print a file holder label from Excel to a dox matrix pri. | Excel Discussion (Misc queries) | |||
Linear Mode
