This documentation is archived and is not being maintained.

Type Property

Office 2003

MsoAnimType can be one of theseMsoAnimType constants.
MsoAnimTypeColor
MsoAnimTypeMixed
MsoAnimTypeMotion
MsoAnimTypeNone
MsoAnimTypeProperty
MsoAnimTypeRoatation
MsoAnimTypeScale
MsoAnimTypeTransition

expression.Type

expression    Required. An expression that returns an AnimationBehavior object.

PpBulletType can be one of these PpBulletType constants.
ppBulletMixed
ppBulletNone
ppBulletNumbered
ppBulletPicture
ppBulletUnnumbered

expression.Type

expression    Required. An expression that returns a BulletFormat object.

MsoCalloutType can be one of these MsoCalloutType constants.
msoCalloutFour
msoCalloutMixed
msoCalloutOne
msoCalloutThree
msoCalloutTwo

expression.Type

expression    Required. An expression that returns a CalloutFormat object.

MsoColorType can be one of these MsoColorType constants.
msoColorTypeCMS
msoColorTypeCMYK
msoColorTypeInk
msoColorTypeMixed
msoColorTypeRGB
msoColorTypeScheme

expression.Type

expression    Required. An expression that returns one of the above objects.

MsoConnectorType can be one of these MsoConnectorType constants.
msoConnectorCurve
msoConnectorElbow
msoConnectorStraight
msoConnectorTypeMixed

expression.Type

expression    Required. An expression that returns a ConnectorFormat object.

MsoDiagramType can be one of these MsoDiagramType constants.
msoDiagramCycle
msoDiagramMixed
msoDiagramOrgChart
msoDiagramPyramid
msoDiagramRadial
msoDiagramTarget
msoDiagramVenn

expression.Type

expression    Required. An expression that returns a Diagram object.

MsoFillType can be one of these MsoFillType constants.
msoFillBackground
msoFillGradient
msoFillMixed
msoFillPatterned
msoFillPicture
msoFillSolid
msoFillTextured

expression.Type

expression    Required. An expression that returns a FillFormat object.

MsoHyperlinkType can be one of these MsoHyperlinkType constants.
msoHyperlinkInlineShape For use in Microsoft Word only.
msoHyperlinkRange
msoHyperlinkShape

expression.Type

expression    Required. An expression that returns a Hyperlink object.

PpPlaceholderType can be one of these PpPlaceholderType constants.
ppPlaceholderBitmap
ppPlaceholderBody
ppPlaceholderCenterTitle
ppPlaceholderChart
ppPlaceholderDate
ppPlaceholderFooter
ppPlaceholderHeader
ppPlaceholderMediaClip
ppPlaceholderMixed
ppPlaceholderObject
ppPlaceholderOrgChart
ppPlaceholderSlideNumber
ppPlaceholderSubtitle
ppPlaceholderTable
ppPlaceholderTitle
ppPlaceholderVerticalBody
ppPlaceholderVerticalTitle

expression.Type

expression    Required. An expression that returns a PlaceholderFormat object.

PpSelectionType can be one of these PpSelectionType constants.
ppSelectionNone
ppSelectionShapes
ppSelectionSlides
ppSelectionText

expression.Type

expression    Required. An expression that returns a Selection object.

MsoShadowType can be one of these MsoShadowType constants.
msoShadow1
msoShadow10
msoShadow11
msoShadow12
msoShadow13
msoShadow14
msoShadow15
msoShadow16
msoShadow17
msoShadow18
msoShadow19
msoShadow2
msoShadow20
msoShadow3
msoShadow4
msoShadow5
msoShadow6
msoShadow7
msoShadow8
msoShadow9
msoShadowMixed

expression.Type

expression    Required. An expression that returns a ShadowFormat object.

MsoShapeType 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

expression.Type

expression    Required. An expression that returns one of the above objects.

PpSoundEffectType can be one of these PpSoundEffectType constants.
ppSoundEffectsMixed
ppSoundFile
ppSoundNone
ppSoundStopPrevious

expression.Type

expression    Required. An expression that returns a SoundEffect object.

PpTabStopType can be one of these PpTabStopType constants.
ppTabStopCenter
ppTabStopDecimal
ppTabStopLeft
ppTabStopMixed
ppTabStopRight

expression.Type

expression    Required. An expression that returns a TabStop object.

PpViewType can be one of these PpViewType constants.
ppViewHandoutMaster
ppViewMasterThumbnails
ppViewNormal
ppViewNotesMaster
ppViewNotesPage
ppViewOutline
ppViewPrintPreview
ppViewSlide
ppViewSlideMaster
ppViewSlideSorter
ppViewThumbnails
ppViewTitleMaster

expression.Type

expression    Required. An expression that returns a View object.

Example

This example loops through all the shapes on all the slides in the active presentation and sets all linked Microsoft 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
				




Show: