View Single Post
  #3   Report Post  
PPCGURU PPCGURU is offline
Banned
 
Location: Mission Beach, CA
Posts: 2
Default

Quote:
Originally Posted by TWR View Post
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