Marcowarnings when pasting chartobjects to powerpoint

[Marie J-son]

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

 

[Tushar Mehta]

The answer to both your questions is "No, you cannot." At least, not
the way you seem to have things set up.

To avoid warnings, don't put the code in each workbook. Instead create
an add-in with application-level events. That way your workbooks will
always be code-free.

To learn more look up application events in XL VBA help. For more
search msdn.microsoft.com. You'll get many hits including
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnword2k2/html/odc_wdappevnt.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vbapp11/html/pphowUsingAppEvents_HV05237994.asp

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

 

[Jon Peltier]

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/
_______