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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.