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