Shape.Type Property (PowerPoint)

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 these MsoShapeType constants.

msoAutoShape
msoCallout
msoCanvas
msoChart
msoComment
msoContentApp
msoDiagram
msoEmbeddedOLEObject
msoFormControl
msoFreeform
msoGroup
msoLine
msoLinkedOLEObject
msoLinkedPicture
msoMedia
msoOLEControlObject
msoPicture
msoPlaceholder
msoScriptAnchor
msoShapeTypeMixed
msoTable
msoTextBox
msoTextEffect

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

See also

Shape Object