Print Preview chart when chart is clicked request.
 

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

Print Preview chart when chart is clicked request.
 

Hi,

You could assign this macro to the chartobject.

Sub ChartPrintPreview()

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

End Sub

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"joecrabtree" wrote in message
...
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