Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adelisa Fischer   on Mar 02 In MS Office Category.

  
Question Answered By: Roderick King   on Mar 02

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.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Replacing shapes on sheet1 with shapes from sheet2 Or get search suggestion and latest updates.


Tagged: