hyperlinks in excel

i am using office 03 for the first time. how does one prevent e-mail
addresses from becoming hyperlinks and eliminate those that are already in
that format. thank you.

mike nolan

Mike

To prevent in the future........

Tools>Autocorrect Options>Autoformat as you type. Uncheck the "replace as you
type" box.

To get rid of current ones you can edit manually or run a macro on a selected
range.

Sub removeAllLinksFromSelection()
Selection.Hyperlinks.Delete
End Sub


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 14:03:02 -0800, "Mike Nolan" <Mike
[email protected]> wrote:

>i am using office 03 for the first time. how does one prevent e-mail
>addresses from becoming hyperlinks and eliminate those that are already in
>that format. thank you.
>
>mike nolan