OLEObject.ZOrder Property (Excel)
Returns the z-order position of the object. Read-only Long.
Syntax
expression .ZOrder
expression A variable that represents an OLEObject object.
Remarks
In any collection of objects, the object at the back of the z-order is collection(1), and the object at the front of the z-order is collection(collection.Count). For example, if there are embedded charts on the active sheet, the chart at the back of the z-order is ActiveSheet.ChartObjects(1), and the chart at the front of the z-order is ActiveSheet.ChartObjects(ActiveSheet.ChartObjects.Count).
Example
This example displays the z-order position of embedded chart one on Sheet1.
MsgBox "The chart's z-order position is " & _
Worksheets("Sheet1").ChartObjects(1).ZOrder