Apr 11 2022 02:31 PM
I can't edit my linked photos in excel. I try to move/resize them and I can't even click them. Is there a way to troubleshoot this? Usually, I can move them right away but eventually, I can't select them and I don't know why.
Apr 12 2022 08:55 AM
Apr 12 2022 08:58 AM
Apr 12 2022 08:59 AM
Apr 14 2022 04:26 AM
Hi @Dbstedman
I do not think that it makes a difference where the picture is located. In the end, it's just an object in Excel and you should at least be able to select it/click on it.
Unfortunately, I do not have any other idea...
Apr 14 2022 06:10 AM
Apr 14 2022 06:38 AM
SolutionObjects 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.
Apr 14 2022 06:58 AM
Apr 14 2022 07:10 AM
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?
Apr 14 2022 10:01 AM
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
Apr 14 2022 06:38 AM
SolutionObjects 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.