ORDER!!!!


Posted by chris on October 12, 2000 11:17 AM

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.

Posted by Ben O. on October 12, 2000 12:17 PM

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



Posted by chris on October 12, 2000 1:08 PM

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.