Howdy,
Our lovely intern copied a bunch of excel charts into Powerpoint 2010 as linked and not embedded objects. Is there a macro to run that would convert these to embedded so we can send it to a client?
Jeff
Howdy,
Our lovely intern copied a bunch of excel charts into Powerpoint 2010 as linked and not embedded objects. Is there a macro to run that would convert these to embedded so we can send it to a client?
Jeff
Try:
[VBA]Sub BreakLinks()
Dim Sld As Slide, Shp As Shape
On Error Resume Next
For Each Sld In ActivePresentation.Slides
For Each Shp In Sld.Shapes
Shp.LinkFormat.BreakLink
Next
Next
End Sub[/VBA]
Cheers
Paul Edstein
[Fmr MS MVP - Word]
The macro will do the job (breaking any other links though) but you do not need a macro to do this.
File > INFO in the right pane near the bottom "edit links to files"
Select the ones to break (ctrl click of shift click) and hit break links.
John Wilson
Microsoft PowerPoint MVP
Amazing Free PowerPoint Tutorials
http://www.pptalchemy.co.uk/powerpoi...tutorials.html