xlDialogPrint arguments

**TWR** · February 15th 10, 06:01 PM posted to microsoft.public.excel.programming

Can someone tell me how to disable the "Print Preview" button in the
xlDialogPrint dialog?

Thanks,

**PPCGURU** · #2 August 6th 12, 06:15 PM

Quote:

Originally Posted by TWR

Can someone tell me how to disable the "Print Preview" button in the
xlDialogPrint dialog?

Thanks,

Bump!

Looking for the answer to this same question. Also I would like to specify the name of the document to print. This is what I have so far.

Quote:

Sub Macro1()
'
' Macro1 Macro
Application.ActivePrinter = "CutePDF Writer on CPW2:"

Application.Dialogs(xlDialogPrint).Show

End Sub

**PPCGURU** · #3 August 6th 12, 07:05 PM

Quote:

Originally Posted by PPCGURU

retval = Application.Dialogs(xlDialogPrint).Show(Arg2:=1, Arg3:=100, Arg4:=5, Arg6:=False)

Found Answer to first disable preview, but I guess I meant I wanted to disable the dialouge box, not the print preview, still looking for that one.

I made this list.

Arg0
Arg1
Arg2 range_num
Arg3 from
Arg4 tocopies
Arg5 draft
Arg6 preview
Arg7 print_what
Arg8 color
Arg9 feed
Arg10 quality
Arg11 y_resolution
Arg12 selection
Arg13 printer_text
Arg14 print_to_file
Arg15 collate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
xldialogprint arguments	TWR	Excel Programming	1	January 25th 10 10:16 AM
Open xldialogprint dialog box	GreenFuze	Excel Programming	2	April 21st 09 04:13 PM
xlDialogPrint	[email protected]	Excel Programming	9	October 18th 08 03:18 AM
application.dialogs(xlDialogPrint) - arguments	David	Excel Programming	0	October 17th 05 08:01 AM
VBA : xlDialogPrint function	Gilbert Aponte[_2_]	Excel Programming	0	October 15th 03 12:23 AM