Edit

Share via

OLEObjects.ZOrder property (Excel)

  • Article

Returns the z-order position of the object. Read-only Long.

Syntax

expression.ZOrder

expression A variable that represents an OLEObjects 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.