can i have it to when i enter an email address it DOESNT become a hyperlink?
i tried to find an option to turn it off but cant find one.

Thanks in advance

choice,

Two options that I can find. In XL 2003 in Tools AutoCorrect Options
AutoFormat as You Type you can turn it off. I don't know in which version
this became available.

Or you could use a WorkSheet_Change event. This checks any entry in Column
B. If it has a hyperlink with an "@" somewhere in it, the hyperlink is
deleted:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B:B")) Is Nothing Then
If Target.Hyperlinks.Count 0 And InStr(Target, "@") < 0 Then
Target.Hyperlinks.Delete
End If
End If
End Sub

In order to use this, paste the code into a worksheet module in the VBE.

hth,

Doug

"choice" wrote in message
...
can i have it to when i enter an email address it DOESNT become a
hyperlink?
i tried to find an option to turn it off but cant find one.

Thanks in advance

In xl2002+, you can turn this off via:

Tools|autocorrect options|autoformat as you type
uncheck the "internet and network paths with hyperlinks"

choice wrote:

can i have it to when i enter an email address it DOESNT become a hyperlink?
i tried to find an option to turn it off but cant find one.

Thanks in advance

--

Dave Peterson