You can find out how to do a lot of things in VBA by recording a macro, performing the actions you want the macro to do, stop recording the macro, and then looking at the VBA code.
Here's the code I got when I moved a rectangle to the back:
Sub Macro2()
ActiveSheet.Shapes("Rectangle 1").Select
Selection.ShapeRange.ZOrder msoBringToFront
End Sub
You'll have to modify the code is you want to change the order of objects without selection them. Good luck,
-Ben
Thanks, I typicly do that but for some reason i didnt think of it. Thank you
Christopher
: There is an option of changing the order of objects(send to the back or bring forward) I can do that manualy and that is fine and dandy, now where can I find out how to do it in VBA? any help would be much appreciated.