Display Print Dialog with "Selection" as Default

[BrI]

I want to display the print dialog box with "Selection" pre-selected as the default under "Print what". Want to give users the option of selecting a printer without also having to choose "selection".



ws.Range("C71:F95").Select

Application.Dialogs(xlDialogPrint).Show  'Displays the print dialog - but how to set default to "Selection"?


Any help appreciated.

[austenr]

try:

Application.Dialogs(xlDialogPrinterSetup).Show

[BrI]

That lets me choose a printer, but doesn't integrate the selection

[Aflatoon]

You can use this:


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

[BrI]

That's just awesome - thank you!