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
 
Back
Top