print dialog box with 2 copies as default?

[Guest]

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

 

[Robert Bruce]

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.