I do have a question. What if I have
more than one worksheet, with more than picture (shape)? The reason
I ask is because worksheets are being added dynamically, as more are
needed, using a template we provide. The worksheet has the pictures
already embedded in their respective cells, but I think that their
names change ("Picture 275" versus "Oval 15" for example). Now I
don't mind selecting each cell on the main worksheet (worksheet1,
called "Dashboard") and deleting the shape in that cell, but I'm not
sure how to do that. Also, on the first worksheet (the dashboard)
there is a legend that displays pictures I don't want to delete. So
a universal "Shapes.SelectAll" may not suffice. Perhaps there is a
way?? to make those shapes found in the legend "read-only"
(protected in some way) so they can't be deleted?? What do you
advise?
I am making a mock-up of the dashboard workbook, with dummy data,
etc., so you can see what I am working with from a structural point
of view.