View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trainer Trainer is offline
external usenet poster
 
Posts: 8
Default linking object to cells

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.
--
Trainer