PDA

View Full Version : Solved: call windows printers



fgarcia90
07-16-2012, 06:04 PM
I have a Sheet4 that is very hidden and by a click of a button I want to call normal windows printers (and normal apperance) to be able to print only that sheet.

(no printout)

as in the attached image.

jolivanes
07-17-2012, 08:45 AM
Application.Dialogs(xlDialogPrinterSetup).Show

The above will show the printer dialog box from which you can select.

If you want to print directly to PDF, have a look at Ron de Bruin's site.

http://www.rondebruin.nl/pdf.htm (http://www.rondebruin.nl/pdf.htm)


http://www.excelguru.ca/content.php?181

Ken Puls has code here to print to PDFCreator

fgarcia90
07-17-2012, 02:41 PM
thanks, but as I posted I wnat the normal windows printer options that normally appear in excel and that command gives a small box to choose...

jolivanes
07-17-2012, 05:30 PM
These are the only ones I know.
Maybe someone else know some others.

Application.Dialogs(xlDialogPrint).Show
Application.Dialogs(xlDialogPrinterSetup).Show
Application.Dialogs(xlDialogPrintPreview).Show

fgarcia90
07-17-2012, 05:44 PM
Solved :)



Application.Dialogs(xlDialogPrint).Show

jolivanes
07-17-2012, 06:10 PM
Glad you found what you needed.
Your good to go now.