How to stop creating an new email msg when I click on a data cell
 

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?

How to stop creating an new email msg when I click on a data cell
 

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?