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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slow Calculations 4
Input Box Cancel 2
Print path linked to cell 1
HP1320 Printing too light 4
Can't get out of "print to file" when trying to print 1
excel 2007 will not print to my default printer 2
Printer purchase help and advice 10
Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6

Back
Top