Marcowarnings when pasting chartobjects to powerpoint
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 |
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 |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com