create a pause in print macro to allow user to select printer

G

Guest

How do I create the pause in the macro to stop at the printer menu command to
allow the user to selct the printer and number of copies
 
G

Guest

Application.Dialogs(xlDialogPrint).Show

There are optional arguments at the end of this function to allow you to
specify a default printer, number of copeis...
 

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

Funcitonality to pause macro?! 13
Stop / Pause a Macro using Pause button 4
How to pause without being "modal" 1
Stop Command Question 4
Printing Via By Macro for Network Printer 2
Pause, print preview, resume macro 4
Pause a macro for user input 15
Pause to select cell 3

Top