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
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for