Supercharge your PowerPoint productivity with
Supercharge your PPT Productivity with PPTools - Click here to learn more.

Proud member of

PPTools

Image Export converts PowerPoint slides to high-quality images.

PPT2HTML exports HTML even from PowerPoint 2010 and 2013, gives you full control of PowerPoint HTML output, helps meet Section 508 accessibility requirements

Merge Excel data into PowerPoint presentations to create certificates, awards presentations, personalized presentations and more

Resize your presentations quickly and without distortion

Language Selector switches the text in your presentation from one language to another

FixLinks prevents broken links when you distribute PowerPoint presentations

Shape Styles brings styles to PowerPoint. Apply complex formatting with a single click.

Ungroup all the OLE objects in a presentation

This macro will ungroup then regroup all of the OLE embedded or linked objects in a presentation. That leaves the object looking (usually) just as it did before but removes any links to data (whether held in the PPT file itself or externally).

Because the data's discarded, the objects will no longer update, and you'll no longer be able to doubleclick to launch the application that created the objects, so you can give your presentation to someone else with no risk that they'll be able to meddle with the data.

This can also shrink some PPT files substantially.

Sub UngroupTheOLEs()

Dim oSlides As Slides
Dim oSld As Slide
Dim oShapes As Shapes
Dim oShp As Shape
Dim oShapeRange As ShapeRange

Set oSlides = ActiveWindow.Presentation.Slides
For Each oSld In oSlides
    Set oShapes = oSld.Shapes
    For Each oShp In oShapes
        If oShp.Type = msoEmbeddedOLEObject Or _ 
        oShp.Type = msoLinkedOLEObject Then
            Set oShapeRange = oShp.Ungroup
            oShapeRange.Group
        End If
    Next oShp
Next oSld

End Sub

See How do I use VBA code in PowerPoint? to learn how to use this example code.


Did this solve your problem? If so, please consider supporting the PPT FAQ with a small PayPal donation.
Page copy protected against web site content infringement by Copyscape Contents © 1995 - 2022 Stephen Rindsberg, Rindsberg Photography, Inc. and members of the MS PowerPoint MVP team. You may link to this page but any form of unauthorized reproduction of this page's contents is expressly forbidden.

Supercharge your PPT Productivity with PPTools

content authoring & site maintenance by
Friday, the automatic faq maker (logo)
Friday - The Automatic FAQ Maker

Ungroup all the OLE objects in a presentation
http://www.pptfaq.com/FAQ00326_Ungroup_all_the_OLE_objects_in_a_presentation.htm
Last update 07 June, 2011
Created: