Edit

Share via

Shape.Type property (PowerPoint)

  • Article

Represents the type of shape or shapes in a range of shapes. Read-only.

Syntax

expression.Type

expression A variable that represents a Shape object.

Return value

MsoShapeType

Remarks

The value of the Type property can be one of the MsoShapeType constants.

Example

This example loops through all the shapes on all the slides in the active presentation and sets all linked Microsoft Office Excel worksheets to be updated manually.

For Each sld In ActivePresentation.Slides 
    For Each sh In sld.Shapes 
        If sh.Type = msoLinkedOLEObject Then 
            If sh.OLEFormat.ProgID = "Excel.Sheet" Then 
                sh.LinkFormat.AutoUpdate = ppUpdateOptionManual 
            End If 
        End If 
    Next 
Next

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.