BrI
09-12-2017, 09:09 AM
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.
ws.Range("C71:F95").Select
Application.Dialogs(xlDialogPrint).Show 'Displays the print dialog - but how to set default to "Selection"?
Any help appreciated.