Ah, I didn't realize a hyperlink can be assigned to a shape.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Dave Peterson wrote:
Yes, assigning a macro would work, but so should assigning a hyperlink.

Jon Peltier wrote:
Shapes do not have hyperlinks. But you can format the text to look like
hyperlinks, and assign a macro to each textbox/rectangle. The macro
needs this line of code:

ActiveWorkbook.FollowHyperlink sAddress

where sAddress is the address of the hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

Rechie wrote:
I tried to insert text box but the hyperlink function is dimmed (not active).


"Jon Peltier" wrote:

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.


.