Hi John,
Thank you for replying!
The 30 optional parameters are prepared for all the excel built-in dialog box. You can find all the excel built-in dialog box from the excel Visaul Basic
Reference with the searching phrase "Built-In Dialog Box Argument Lists"(without quotation). You will find the help documentation "Built-In Dialog Box
Argument Lists" in the search result.
For the xlDialogPrint dialog box, the definition is as below:
Dialog box constant Argument list(s)
-------------------- -----------------
xlDialogPrint range_num, from, to, copies, draft, preview, print_what,
color, feed, quality, y_resolution, selection, printer_text,
print_to_file, collate
There are 16 arguments in the argument list for xlDialogPrint. This means xlDialogPrint built-in dialog box only uses 15 parameters of Show methods.
Then you can specify the value accroding to the scenario for each arguments.
Furthermore, you can also check the the VBA reference documentation for Excel 2002 Built-in dialog box from Microsoft.com. Please go to:
Built-In Dialog Box Argument Lists
http://msdn.microsoft.com/library/de...ogArgLists.asp
Please feel free to let me know if you have any further questions.
Does this answer your question? Thank you for using Microsoft NewsGroup!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.