Hi

I use the VBA code:

Application.Dialogs(xlDialogPrint).Show

To invoke the Print Dialog Box.

In addition to the above, once the Print Dialog Box
shows up - I would like the "Number of copies" to
be set to 3 instead of the default 1.

How can I do this with VBA code?

Thanks,

Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/