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" wrote in message
...
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
|