Date:    Wed, 8 Jun 2005 15:34:08 -0400
From:    Bob Lendrim <[log in to unmask]>
Subject: Excel and hyperlinks

I use Excel 2000 to keep a list of email addresses. When an address is
entered in a cell, Excel, by default, makes it a hyperlink. It is possible,
but time consuming, to eliminate the hyperlinks one at a time. Can anyone
tell me how to change Excel so it doesn't create hyperlinks automatically?
Thank you, Bob

Bob, I found a tip and a snippet of code from this website forum and copied
it directly. Credit goes to Gord Dibben.


 "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"

Hope this helps.
Chris Ryan
[log in to unmask]

        The NOSPIN Group has added a new feature on our website,
           web based bulletinboard for questions and answers:
              Visit our sister website at http://nospin.com