View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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