Logo 
Search:

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: 407
  

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?

Share: 

 

2 Answers Found

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

Application.Dialogs(xlDialogPrint).Show

or

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.




Tagged: