hyperlink on part of a text contained in a cell

  • Thread starter Thread starter Cajeto 63
  • Start date Start date
C

Cajeto 63

Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google only.

Thank you.
 
Excel doesn't support this kind of thing.

But you could cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) and
assign a hyperlink to that rectangle.
 
Thank you Dave for that fast and easy trick that will work fine.

--


Regards, Cajeto 63.





Dave Peterson said:
Excel doesn't support this kind of thing.

But you could cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) and
assign a hyperlink to that rectangle.
Click to expand...
 
Hi,

A possible appearance work around would be,
Apply hyperlink to the whole cell. Then edit the cells font attributes.
Remove blue colour and underline. Now edit the cell content and select only
the word Google.
Reapply Blue font with underline.

The whole cell will act as hyperlink but only Google will look like
hyperlink.

Cheers
Andy
 
Try this routine:

Sub AddCellHyperlink()
' Select cell on the worksheet to place the hyperlink
'
cellcontents = InputBox("Enter Cell Display", "Hyperlink Cell Display", _
Default:=ActiveCell.Value)
If cellcontents = "" Then Exit Sub
ActiveCell.Formula = cellcontents

webaddress = InputBox("Enter Web Address:" & Chr(13) & _
"Example: http://www.google.com", "Hyperlink Address", _
Default:="http://www.google.com/")
If webaddress = "" Then Exit Sub

With Worksheets(1)
.Hyperlinks.Add ActiveCell, webaddress
End With
End Sub

J Knowles
 
Back
Top