Paste Excel chart in Powerpoint - how to "send to back" the pasted chart
 

Hello,

I have a code that pastes a few Excel charts into different slides. It works fine, but I want to reuse the slides and update them daily. The problem is that there is a box that should be on top of each chart, and when the macro pastes the charts, it places them on top, leaving the box hidden behind.

Is there a way to move the selected shape as in "send to back"?

I was expecting to find something like:
PPApp.ActiveWindow.Selection.ShapeRange.xxx
that would do the trick... but I can't seem to find it.

Any help?
Thanks!

Paste Excel chart in Powerpoint - how to "send to back" thepasted chart
 

On Saturday, November 17, 2012 5:06:41 PM UTC+1, Jose wrote:
Hello,



I have a code that pastes a few Excel charts into different slides. It works fine, but I want to reuse the slides and update them daily. The problem is that there is a box that should be on top of each chart, and when the macro pastes the charts, it places them on top, leaving the box hidden behind.



Is there a way to move the selected shape as in "send to back"?



I was expecting to find something like:

PPApp.ActiveWindow.Selection.ShapeRange.xxx

that would do the trick... but I can't seem to find it.



Any help?

Thanks!


Found it. Just in case anyone needs it too:

PPApp.ActiveWindow.Selection.ShapeRange.ZOrder msoSendToBack

It was right there :)