Print dialog box selection macro

G

Guest

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Printing 5
Print workbook tabs based on a selection list 1
Macro to Copy Sheets to new workbook 18
Print Area Macro Question 2
Assign Macro Dialog Box 6
Custom Dialog Box Macro for Excel 3
Excel VBA - Problem with Closing Print Preview 0
what do I add to my macro to include details from a check box?? 4

Top