Obscured Property

Microsoft Excel Visual Basic

Obscured Property

       

True if the shadow of the specified shape appears filled in and is obscured by the shape, even if the shape has no fill. False if the shadow has no fill and the outline of the shadow is visible through the shape if the shape has no fill. Read/write MsoTriState.

MsoTriState can be one of these MsoTriState constants.
msoCTrue
msoFalse The shadow has no fill and the outline of the shadow is visible through the shape if the shape has no fill.
msoTriStateMixed
msoTriStateToggle
msoTrue The shadow of the specified shape appears filled in and is obscured by the shape, even if the shape has no fill.

expression.Obscured

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

This example sets the horizontal and vertical offsets for the shadow of shape three on myDocument. The shadow is offset 5 points to the right of the shape and 3 points above it. If the shape doesn't already have a shadow, this example adds one to it. The shadow will be filled in and obscured by the shape, even if the shape has no fill.

Set myDocument = Worksheets(1)
With myDocument.Shapes(3).Shadow
    .Visible = True
    .OffsetX = 5
    .OffsetY = -3
    .Obscured = msoTrue
End With