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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - create a pause in print macro to allow user to select printer (https://www.excelbanter.com/excel-programming/339398-create-pause-print-macro-allow-user-select-printer.html)

Scott53

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

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

Jim Thomlinson[_4_]

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

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...
--
HTH...

Jim Thomlinson

"Scott53" wrote:

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

All times are GMT +1. The time now is 12:10 AM.