Marie -
Copy the charts as pictures in the first place. Hold shift while selecting the Edit
menu, and Copy becomes Copy Picture. I prefer the On Screen and As Picture options.
Then in PowerPoint simply paste.
For more info, see
http://peltiertech.com/Excel/XL_PPT.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Marie J-son wrote:
Hi,
When I paste a chartobject from a worksheet to powerpoint, 3 macrowarnings
in a row occur.
I have code running when opening and closing the file and code running when
activating/deactivating the worksheet - this is the cause to the warnings, I
guess.
How can I get rid of them?
Is there a way to trap when someone try to link information and then only
allow picturepaste ?
I wouldn't want to allow linking objects at all if it is possible, but I
must be able to paste chartobjects as pictures in powerpoint. This maybe
could be the answer to both questions
/Kind Regards