If I draw a new shape in my spreadsheet I want it to automatically be "Sent to the back", is there a way I can do this, perhaps by using some sort of VB code in the Worksheet open module? Any other way?
Thanks
If I draw a new shape in my spreadsheet I want it to automatically be "Sent to the back", is there a way I can do this, perhaps by using some sort of VB code in the Worksheet open module? Any other way?
Thanks
You mayu use this code:
I hope it can help you.![]()
Sub Macro2() For Each sh In ActiveSheet.Shapes sh.ZOrder msoSendToBack Next End Sub
Regards,
Antonio
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks