Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting when pasting into excel | Excel Discussion (Misc queries) | |||
pasting into an excel template without losing the formatting | Excel Discussion (Misc queries) | |||
Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel |