| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Print Selection" doesn't print beyond automatic page breaks | Excel Discussion (Misc queries) | |||
| Collate check box in the Print Dialog Box | Setting up and Configuration of Excel | |||
| How can I print frozen panes to appear above print selection in Ex | Excel Discussion (Misc queries) | |||
| print prevu button brings rights management dialog box - how do i | Setting up and Configuration of Excel | |||
| How do I reduce the highth of the print dialog box in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
