ExcelBanter - Print dialog box selection macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Print dialog box selection macro (https://www.excelbanter.com/excel-discussion-misc-queries/164682-print-dialog-box-selection-macro.html)

I think I need to rephrase the question

Print dialog box selection macro

I have a macro that opens the print dialog box. I would like the "Print What
- selection" option to be selected by default instead of "Activesheets". Is
there any code that can do this?

Steve Yandl

Print dialog box selection macro

Try

Application.Dialogs(xlDialogPrint).Show arg12:=1

Steve

"I think I need to rephrase the question"
osoft.com wrote in
message ...
I have a macro that opens the print dialog box. I would like the "Print
What
- selection" option to be selected by default instead of "Activesheets".
Is
there any code that can do this?

I think I need to rephrase the question

Print dialog box selection macro

Thanks Steve. That works great

"Steve Yandl" wrote:

Try

Application.Dialogs(xlDialogPrint).Show arg12:=1

Steve

"I think I need to rephrase the question"
osoft.com wrote in
message ...
I have a macro that opens the print dialog box. I would like the "Print
What
- selection" option to be selected by default instead of "Activesheets".
Is
there any code that can do this?

All times are GMT +1. The time now is 05:32 AM.