Re: Marcowarnings when pasting chartobjects to powerpoint

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jon Peltier (jonREMOVExlmvp_at_peltierCAPStech.com)
Date: 03/03/05 

Date: Wed, 02 Mar 2005 21:54:07 -0500

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 work*** 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 work*** - 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
>
>
>

Quantcast