Excel vba: .ZOrder-property does not change the order of the shapes in the "Selection pane"

82 Views Asked by At

I was wondering if anyone could answer why the change of .ZOrder-property does not change the order of the shapes in the "Selection pane" (see first picture).

Luckily for me, the code works as intended, where things are reorganized to be displayed as the order given prior to running the code. (See code in the bottom). This code is needed as the code groups and ungroups some chartobjects which first have a user-defined order, but during the grouping-action the charts become chronologically listed, then I have made a code that rearranges the single charts back to the original order when ungrouped again.

Regards Hallvard

Selection pane

Code that is rearranging shapes

0

There are 0 best solutions below