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

J

jj416

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?
 
G

Gord Dibben

To stop this happening in the future, go to Tools>Autocorrect Options>Autoformat
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
 
Top