Printing code

[Jase]

I am trying to set up a printing macro. I currently have connected to a
command button setup to print. When i hit my command button I have an input
box that asks me how many copies to print. However I have no choice to which
printer that I want to select, it goes to my default printer. Any ideas how I
could also add the choice of which printer to select within my input box or
to use something else besides an inout box?

thanks,

Jase

 

[Jim Thomlinson]

Add this line of code allowing the user to select their printer...

Application.Dialogs(xlDialogPrinterSetup).Show

 

[Jase]

That is exactly what I am looking for, thanks.

Jase