ExcelBanter - can I get the printer options to display with the print icon

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - can I get the printer options to display with the print icon (https://www.excelbanter.com/excel-programming/345168-can-i-get-printer-options-display-print-icon.html)

Billyd

can I get the printer options to display with the print icon

Currently when I click the printer icon it goes directly to default printer
and prints what I would like is to display printer options, be able to slect
a printer and other print functions

K Dales[_2_]

can I get the printer options to display with the print icon

In ThisWorkbook, set up the Workbook_BeforePrint() event procedu
Private Sub Workbook_BeforePrint(Cancel As Boolean)

Application.Dialogs(xlDialogPrinterSetup).Show

End Sub

--
- K Dales

"Billyd" wrote:

Currently when I click the printer icon it goes directly to default printer
and prints what I would like is to display printer options, be able to slect
a printer and other print functions

All times are GMT +1. The time now is 05:29 AM.