linking object to cells

[Trainer]

I have a workbook with two worksheets. The first worksheet (01) has a
picture of cells A4: J25 in the second worksheet (02). I would like that
when I double click the screendump in sheet01 it takes me to cells A4:E4 in
sheet 2, I've managed this by using a hyperlink. However, I would also like
that when any cells in the given range in sheet 02 are updated the picture in
sheet01updates with the information from sheet02 as well. I've tried pasting
the picture as a link, but the paste link button is inactive, how do I get
round this.

 

[challa prabhu]

Hi,

Your first part of the paragraph is what will actualy happen, but if you
would like the given cell in Sheet 2 to automatically update in Sheet 1,
this will not happen, because the Sheet 1 range is already defined as
picture. You can only do this outside the picture range in sheet 1.


Challa Prabhu