Excel drawings with Hyperlink

Hello:

I would like to create a hyperlink when a particular serial number is
selected in a cell. Is there a way to create small drawings in excel and
have those drawings pop up (or via hyperlink) when a given serial number is
selected from a cell? I have created drawings in Paint and saved them as
JPEG images, but when I select a serial number the Paint editor pops up at
full screen with a tiny image.

Regards,

D.Parker

What I have done in the past was insert drawings on the worksheet, hide
them, then associate VBA code to unhide the desired drawing (picture) and
hide all others.

You can select the desired serial number by having a button, or (an old
trick that may be outdated) draw a rectangle (from the Drawing toolbar) over
the cell , set to no fill and no border (so it is not visible) and assign a
macro to it. Then you "click on the cell" to activate the macro.

There's probably slicker ways to do this but it works.


"D.Parker" <[email protected]> wrote in message
news:[email protected]...
> Hello:
>
> I would like to create a hyperlink when a particular serial number is
> selected in a cell. Is there a way to create small drawings in excel and
> have those drawings pop up (or via hyperlink) when a given serial number
> is
> selected from a cell? I have created drawings in Paint and saved them as
> JPEG images, but when I select a serial number the Paint editor pops up at
> full screen with a tiny image.
>
> Regards,
>
> D.Parker

D.

JE McGimpsey's lookuppics site is the place to go for info on this subject.

http://www.mcgimpsey.com/excel/lookuppics.html

Involves event code to bring up the pics..


Gord Dibben Excel MVP

On Tue, 3 May 2005 14:11:18 -0700, "D.Parker"
<[email protected]> wrote:

>Hello:
>
>I would like to create a hyperlink when a particular serial number is
>selected in a cell. Is there a way to create small drawings in excel and
>have those drawings pop up (or via hyperlink) when a given serial number is
>selected from a cell? I have created drawings in Paint and saved them as
>JPEG images, but when I select a serial number the Paint editor pops up at
>full screen with a tiny image.
>
>Regards,
>
>D.Parker