Hopefully this will come across right ? I have a macro using the following to bring a shape to the front:
When I make a copy of that sheet the shape becomes a different number for ex. "Rectangle 447" becomes "Rectangle 445" and the macro will not work properly on that copied sheet. Is there any fix for this?![]()
ActiveSheet.Shapes("Rectangle 447").Select Selection.ShapeRange.ZOrder msoBringToFront
Thanks in advance,
Beatnik
Bookmarks