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 |
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