Printing code

  • Thread starter Thread starter Jase
  • Start date Start date
J

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
 
Add this line of code allowing the user to select their printer...

Application.Dialogs(xlDialogPrinterSetup).Show
 
Back
Top