Solved: set printer to 2 copies automatically

[wilg]

I use the below code to bring up the print dialogue to promt my user to print. They can select yes or no. But I want the number of copies to be set for 2 automatically. Righ now is is auto set for 1 when the dialogue box appears.

Any way to set to 2?


Application.Dialogs(xlDialogPrint).Show

[Kenneth Hobs]

Application.Dialogs(xlDialogPrint).Show , , , 2

You can not use named arguments. Use the position to set what you want. The arguments are:

xlDialogPrint range_num, from, to, copies, draft, preview, print_what, color, feed, quality, _ y_resolution, selection, printer_text, print_to_file, collate

[wilg]

Perfect, thanks Kennith.