Print Preview chart when chart is clicked request.

[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

 

[Andy Pope]

Hi,

You could assign this macro to the chartobject.

Sub ChartPrintPreview()

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

End Sub

Cheers
Andy