View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jose[_4_] Jose[_4_] is offline
external usenet poster
 
Posts: 4
Default 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 :)