Print dialog box selection macro

  • Thread starter I think I need to rephrase the question
  • Start date
I

I think I need to rephrase the question

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?
 
S

Steve Yandl

Try

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


Steve



"I think I need to rephrase the question"
 
I

I think I need to rephrase the question

Thanks Steve. That works great

Steve Yandl said:
Try

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


Steve



"I think I need to rephrase the question"
Click to expand...
 
Top