Jump from cell to new sheet?

  • Thread starter Thread starter Don Culp
  • Start date Start date
D

Don Culp

Is there a way to click on a cell to cause a specified sheet to open? What I
want to do is put a thumbnail image in a cell and then have the full image
in another sheet; then when I click on the thumbnail, the other sheet will
open and the full image will be displayed.

Excel 2003, SP3
Windows XP Pro, SP2

Thanks,
Don Culp
 
Is there a way to click on a cell to cause a specified sheet to open? What I
want to do is put a thumbnail image in a cell and then have the full image
in another sheet; then when I click on the thumbnail, the other sheet will
open and the full image will be displayed.

Excel 2003, SP3
Windows XP Pro, SP2

Thanks,
Don Culp
Click to expand...

write a macro to open the main picture and assign it to the thumbnail
click.
 
Hi Don,

To do this without VBA macros, try locating first the Camera tool from the
toolbar menu. This tool enables you to take a "snapshot" of defined a range
in a sheet (for this example, a range from sheet 2). The snapshot can be
placed on sheet 1 and can be resized as necessary (to thumbnail size if
needed). To go back to sheet 2 simply double click on the snapshot in sheet 1.

Hope this helps!
 
I'm not sure if you mean you want a workbook to be opened or you want to go to a
different worksheet in the same workbook, but either way, you could assign a
hyperlink to the picture.

Rightclick on the picture and choose: Hyperlink
 
Back
Top