On Sep 9, 12:27*pm, "Jim Rech" wrote:
Application.Dialogs(xlDialogPrinterSetup).Show

--
wrote in message

...
| Good afternoon. I used VBA to format the pages I want printed.
| However, when they press the Print icon I developed for them, I want
| the xlDialogPrint to appear so they can select an appropriate printer.
| The xlDialogPrint box appears, but I only want them to use the dialog
| box to select a printer. Once they select the printer and press OK,
| the worksheets will print based on the print definitions in the VBA. I
| don't want them to be able to adjust any of the other arguments, as
| I've already defined those arguments in the VBA code. Is it possible
| for me to use VBA code to disable all arguments of the xlDialogPrint
| box, except the printer selection argument? Thanks for your time.
|
| Michael

Thanks, Jim. The xlDialogPrinterSetup allows me to select a printer.
Once I press OK, though, the worksheets do not print.