PPCGURU

Banned

Location: Mission Beach, CA

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 07:58 AM.

About Us

"It's about Microsoft Excel"