How do I make a field with email addresses hyper?

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.

There may be a better way, but this works:

Select (click on or use the arrow keys to go to) the cell, press F2 and
then press the Enter key

Hope this helps.... :Bgr


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123086

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

On Thu, 06 Aug 2009 08:44:58 -0700, Christopher Glenn wrote:

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.

Thanks Gord, but I think I'll go with the newbie method. The F2+Enter
also automatically moves to the next cell down in the same row, so
it's quick work to do them.


On Thu, 06 Aug 2009 11:15:59 -0700, Gord Dibben gorddibbATshawDOTca
wrote:

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

On Thu, 06 Aug 2009 08:44:58 -0700, Christopher Glenn wrote:

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.

Just for future reference, I think Gord's method is meant to be used by
first selecting _all_ the cells that have the email address text in them
and then running the macro once.

The intersection described in

For Each Cell In Intersect(Selection,
Selection.SpecialCells(xlConstants, xlTextValues))

would pick up all cells of interest in a group of selected cells, even
if some of the selected cells had numbers or cell formulas in them
(that's done with the xlConstants and xlTextValue parameters to the
SpecialCells method)...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123086

Sorry

I should have explained that select all the pertinent cells first then run
the macro.


Gord

On Thu, 06 Aug 2009 12:38:34 -0700, Christopher Glenn wrote:

Thanks Gord, but I think I'll go with the newbie method. The F2+Enter
also automatically moves to the next cell down in the same row, so
it's quick work to do them.


On Thu, 06 Aug 2009 11:15:59 -0700, Gord Dibben gorddibbATshawDOTca
wrote:

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

On Thu, 06 Aug 2009 08:44:58 -0700, Christopher Glenn wrote:

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.