SetShapesDefaultProperties Method

Applies To

Shape object, ShapeRange collection object.

Description

Applies the formatting for the specified shape to the default shape. Shapes created after this method has been used will have this formatting applied by default.

Syntax

expression.SetShapesDefaultProperties

expression Required. An expression that returns a Shape or ShapeRange object.

Example

This example adds a rectangle to myDocument, formats the rectangle's fill, applies the rectangle's formatting to the default shape, and then adds another smaller rectangle to the document. The second rectangle has the same fill as the first one.

Set myDocument = Worksheets(1)
With mydocument.Shapes
    With .AddShape(msoShapeRectangle, 5, 5, 80, 60)
        With .Fill
            .ForeColor.RGB = RGB(0, 0, 255)
            .BackColor.RGB = RGB(0, 204, 255)
            .Patterned msoPatternHorizontalBrick
        End With
        .SetShapesDefaultProperties     ' Sets formatting for default shapes.
    End With
    ' New shape has default formatting.
    .AddShape msoShapeRectangle, 90, 90, 40, 30
End With