| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLDialogPrint - PrintWhat- Selection Option
Sub AABB()
res = Application.Dialogs( _ xlDialogPrint).Show(, , , , , , , , , , , 1) End Sub worked for me. -- Regards, Tom Ogilvy "TonyD" wrote: Is there any way that I can make the windows printer dialogue box appear and select the option "Selection" automatically in the "Print_What" area? I tried the following but it doesn't select "Selection" and when I try to print it keeps coming back. Application.Dialogs(xlDialogPrint).Show ,,,,,,selection |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Testing a group of option buttons for a selection. | Excel Programming | |||
| Controlling the 'cancel' button in xldialogprint | Excel Programming | |||
| Tools - Option - "move selection after enter" | Excel Worksheet Functions | |||
| Other option of InputBox for range selection | Excel Programming | |||
| VBA : xlDialogPrint function | Excel Programming | |||
Threaded Mode
