Hyperlink

[tkaplan]

Is there a way for me to make only part of the text in a cell a hyperlink?
For example, if my cell text says:

Open up the full and part report.
I want that if my user clicks the word "full", one thing opens, if clicks "part", something else opens.

Is there any way to do this?

[Dave Peterson]

One hyperlink per cell.

But you could cheat. Put a rectangle (from the drawing toolbar) over each word.

Assign different links to each rectangle.

Format the rectangle so the borders don't show. Format the text in
Blue/underscore so that it looks like a hyperlink.

You might even fool your users!

tkaplan wrote:
>
> Is there a way for me to make only part of the text in a cell a
> hyperlink?
> For example, if my cell text says:
>
> Open up the full and part report.
> I want that if my user clicks the word "full", one thing opens, if
> clicks "part", something else opens.
>
> Is there any way to do this?
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=476358

--

Dave Peterson

[tkaplan]

great idea
Thank you!