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

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

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!
 
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 problemis 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!
Click to expand...


Found it. Just in case anyone needs it too:

PPApp.ActiveWindow.Selection.ShapeRange.ZOrder msoSendToBack

It was right there :)
 
Back
Top