Shape.ZOrder Method (Excel)

Moves the specified shape in front of or behind other shapes in the collection (that is, changes the shape's position in the z-order).

expression .ZOrder(ZOrderCmd)

expression A variable that represents a Shape object.

Parameters

Name

Required/Optional

Data Type

Description

ZOrderCmd

Required

MsoZOrderCmd

Specifies where to move the specified shape relative to the other shapes.

MsoZOrderCmd can be one of these MsoZOrderCmd constants.

msoBringForward

msoBringInFrontOfText. Used only in Microsoft Word.

msoBringToFront

msoSendBackward

msoSendBehindText. Used only in Microsoft Word.

msoSendToBack

Use the ZOrderPosition property to determine a shape's current position in the z-order.

This example adds an oval to myDocument and then places the oval second from the back in the z-order if there is at least one other shape on the document.

Set myDocument = Worksheets(1) 
With myDocument.Shapes.AddShape(msoShapeOval, 100, 100, 100, 300) 
    While .ZOrderPosition > 2 
        .ZOrder msoSendBackward 
    Wend 
End With

Concepts

Other resources

Show:
© 2014 Microsoft