Thread: can I get the printer options to display with the print icon
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default 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
Reply With QuoteReply With Quote