Jump from cell to new sheet?

[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

 

[Nayab]

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

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

 

[RaymundCG]

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!

 

[Dave Peterson]

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