Link to email address--not wanted

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Shelledy - 01 Dec 2006 23:24 GMT

I maintain a directory of homeowner association members in Excel. One of the
columns is the e-mail address of each member. Formerly the file was in Excel
97. Moved it to a computer running Excel 2002. Now the new e-mail address
entries are in executable form (excuse ignornace of Internet
terms--hyperlink?), i.e. when I click on the cell, the program attempts to
send an e-mail to that address. This is not what I want. I've tried
formatting the cell differently, to no avail. How do I turn off this
feature, so that the addresses go in as ordinary text?

Reply to this Message

macropod - 03 Dec 2006 02:47 GMT

Hi Frank,

For an individual cell, you could use Insert|Hyperlink|Remove Link. Gets a
bit tedious with lots of cells, though.

For any selected cells, you could use a macro like:

Sub KillHyperlinks()
Dim oRange As Range
Dim oCell As Range
If Selection.Columns.Count * Selection.Rows.Count = 1 Then
Set oRange = ActiveCell
Else
Set oRange = Selection.SpecialCells(xlConstants)
End If
For Each oCell In oRange
oCell.Hyperlinks.Delete
Next oCell
End Sub

Cheers

Signature

macropod
[MVP - Microsoft Word]

> I maintain a directory of homeowner association members in Excel. One of the
> columns is the e-mail address of each member. Formerly the file was in Excel
[quoted text clipped - 4 lines]
> formatting the cell differently, to no avail. How do I turn off this
> feature, so that the addresses go in as ordinary text?

Reply to this Message

David McRitchie - 09 Dec 2006 03:26 GMT

Or a bit simpler and a lot faster.
Sub DelHyperlinks()
Selection.Hyperlinks.Delete
End Subsee http://www.mvps.org/dmcritchie/excel/buildtoc.htm- ---HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages:

> Hi Frank,
>
[quoted text clipped - 28 lines]
> > formatting the cell differently, to no avail. How do I turn off this
> > feature, so that the addresses go in as ordinary text?

Reply to this Message

RichardSchollar - 16 Dec 2006 11:38 GMT

Hi Frank

To turn this feature off, go Tools>Autocorrect Options>Autoformat As
You Type and uncheck "Internet and network paths with hyperlinks".

You'll need to use the macro procedure to remove existing hyperlinks
though - the above will only stop Excel from introducing new
hyperlinks.

Hope this helps!

Richard

Reply to this Message