Print Preview chart when chart is clicked request.

  • Thread starter Thread starter joecrabtree
  • Start date Start date
J

joecrabtree

To all,

I have an xy chart. When the user clicks on it I would like it to open
up in the print preview window ready to print. The chart is embedded
in a worksheet called 'chart' and not in its own worksheet.

Any help you could give me with this would be greatly appreciated.

Regards

Josep Crabtree
 
Hi,

You could assign this macro to the chartobject.

Sub ChartPrintPreview()

ActiveSheet.ChartObjects(Application.Caller).Chart.PrintPreview

End Sub

Cheers
Andy
 

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

Print problems w/ charts excel 2003/2007 3
Copy embedded chart with updated data request 2
Printing Charts Macro Help 1
Chart events 2
[C#] Excel Print Dialog 0
Why do charts disappear? 2
Absolute Scale of Chart Printout 4
Embedded Chart protection 1

Back
Top