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

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!
 
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 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!


Found it. Just in case anyone needs it too:

PPApp.ActiveWindow.Selection.ShapeRange.ZOrder msoSendToBack

It was right there :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top