Printer Dialog Box

[vestax22]

Hi, I know I'm asking a lot of questions but here is another one for you.

I have a macro inside my excel application that sets printer settings for a specific worksheet whan pressing on a botton. I select a range and then print it out but I want the user to be able to select a printer instead of sending to the default printer. Is there a way pop up the printer dialog box after setting the printer settings?

Thx in advance

 

[Bowers74]

Hi vetax22,

Ask as many questions as you want, that is what this forum is for.

Now to your question. Add this code to your application. It calls up the Print screen (same as File->Print...).

Sub PrinterDialog()
Application.Dialogs(xlDialogPrint).Show
End Sub

Hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!