MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Printing a chart

  Asked By: Manju    Date: Feb 21    Category: MS Office    Views: 536

I used the recording feature to create a macro to print a graph.
It does not bring up the dialog box to select a printer.
It prints to the windows default printer.
How do you make it display a dialog box?



2 Answers Found

Answer #1    Answered By: Mehreen Malik     Answered On: Feb 21



result = Application.Dialogs(xlDialogPrint).Show

where 'result' contains true or false depending on whether the cancel
button/window was closed with the top-right 'X' or not.

Answer #2    Answered By: Daya Sharma     Answered On: Feb 21

I think what you're looking for is:

dlgAnswer = Application.Dialogs(xlDialogPrint).Show

Didn't find what you were looking for? Find more on Printing a chart Or get search suggestion and latest updates.