I want to link a few sites to some cells in excel. I would like place a
link within specific text.
Ex. _Link_name (\"http://www.google.com\")_ and have
the URL hidden. Link example goes to Google.com.
Thank you,
Joe


--
JoeStL
------------------------------------------------------------------------
JoeStL's Profile: http://www.excelforum.com/member.php...o&userid=29080
View this thread: http://www.excelforum.com/showthread...hreadid=491317

I'm not sure you can hide the tooltip that shows up when you let the mouse hover
over the cell.

Maybe you could add a shape to the worksheet and then assign a macro to that
shape. The macro could follow the hyperlink.

For instance, I added a couple of rectangles to a worksheet and assigned the
same macro to both of them:

Option Explicit
Sub myLink()

Dim myHyperLink As String

myHyperLink = ""
Select Case LCase(Application.Caller)
Case Is = "rectangle 3": myHyperLink = "http://www.google.com"
Case Is = "rectangle 4": myHyperLink = "http://www.microsoft.com"
End Select

If myHyperLink = "" Then
Beep
Else
ThisWorkbook.FollowHyperlink Address:=myHyperLink, NewWindow:=True
End If

End Sub


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

JoeStL wrote:

I want to link a few sites to some cells in excel. I would like place a
link within specific text.
Ex. _Link_name (\"http://www.google.com\")_ and have
the URL hidden. Link example goes to Google.com.
Thank you,
Joe

--
JoeStL
------------------------------------------------------------------------
JoeStL's Profile: http://www.excelforum.com/member.php...o&userid=29080
View this thread: http://www.excelforum.com/showthread...hreadid=491317

--

Dave Peterson