print dialog box with 2 copies as default?

J

Johan

I want the print dialog box to show with 2 copies as default.

this code doesn't work:
With Application.Dialogs(xlDialogPrint).copies = 2
..Show
End With

thanks
 
R

Robert Bruce

Roedd said:
this code doesn't work:
With Application.Dialogs(xlDialogPrint).copies = 2
.Show
End With

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

The arguments for built in dialogs are in the help file, but you have to
dig.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.
 

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

Top