Forum Discussion
Linked Picture Troubleshooting
Objects can also be selected from within the selection pane (Home/Editing/Find&Select/SelectionPane.
Thing like multi-selection as changing the z-order are easier here but, if the sheet and objects are protected, then you will also be unable to select them from the pane.
Objects can also be selected from within the selection pane (Home/Editing/Find&Select/SelectionPane.
Thing like multi-selection as changing the z-order are easier here but, if the sheet and objects are protected, then you will also be unable to select them from the pane.
So basically the visible "Picture 24" is what I want to be on top. I already sent it to front, but it is still below that white line and won't move up further. Those hidden pictures are all copies that overlap the original that I can't select, delete, or send to the background. Is there any way to troubleshoot this?
I don't think I have ever seen the situation in which some objects are selectable and, hence, may be deleted, and others are not. I am not sure what the 'white line' is other than, possibly, the highlight indicating the selected objects.
It is also possible to read the properties of any given shape from the Worksheet Shapes Collection using VBA and to apply a limited set of methods such as 'shp.delete' but, to be honest, I see no reason that should work better than performing the task from the GUI.
Sub inspectShape() Dim sh As Shape Set sh = ActiveSheet.Shapes(2) sh.Delete End Sub