How do I initiate the windows printer select object in Excel macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that was created in Excel that as a control number on it. I
have placed a button on the worksheet which asks how many copies. It
increments the control number by one, prints and then repeats until all have
been printed. The printout method simply uses the default or selected
printed. I need to know how to bring up the standad windows printer
selection object so I can select the printer (the same object that comes up
when you press ctrl-P.
 
Mick,

Use

application.Dialogs(xlDialogPrint).Show ,,,myNumCopies

and substitute myNumCopies with your variable
 

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

Print specific range but user to select printer 4
User select printer in print macro 7
Printing with watermark in Excel 2
How to read settings from xlDialogPrint 1
Print macro using xlDialogPrinterSetup fails to use driver-specific settings 0
Select cells in 2 sheets to print in one instance 4
printing out via vb and selecting the printer 1
How to let the user select a printer and then print? 3

Back
Top