I have created a large customer list, one column of which does have email
addresses and one has web sites listed. Now alot of the cells throughout the
database creates a new email message when you click on the cell. What did I
do to start this and how do I stop it?

To stop this happening in the future, go to ToolsAutocorrect OptionsAutoformat
as you type and uncheck "internet and network paths with hyperlinks"

To get rid of current hyperlinks manually select and "Remove Hyperlink" or use
this macro from David McRitchie.

Sub DelHyperlinks()
Selection.Hyperlinks.Delete
End Sub


Gord Dibben MS Excel MVP

On Tue, 10 Oct 2006 14:54:02 -0700, jj416
wrote:

I have created a large customer list, one column of which does have email
addresses and one has web sites listed. Now alot of the cells throughout the
database creates a new email message when you click on the cell. What did I
do to start this and how do I stop it?