Print Dialog from VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a VBA command that will call up the print dialog box before printing
so that number of pages, preview, etc. can be modified? .PrintOut isn't
doing it for me.

Thank you for your help.
 
shagthewag said:
Is there a VBA command that will call up the print dialog box before
printing so that number of pages, preview, etc. can be modified?
.PrintOut isn't doing it for me.
Click to expand...

stw

application.Dialogs(xlDialogPrint).Show
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
If no default printer Open Print Diablog box 2
Print specific range but user to select printer 4
Get Control Before AND After Printing 1
Print Entire Workbook 6
BeforePrint Event - "PrintOut" does not give Print Dialog 2
Print macro using xlDialogPrinterSetup fails to use driver-specific settings 0
Prevent Printing in Print Preview? 4

Back
Top