how do I deactivate multiple e-mail address hyperlinks in excel

K

kattnip

I have a list of names etc including e-mail addresses and everytime I put an
e-mail address in it's in the form of a hyperlink and I have to manually
deactivate it. I would like to setup the sheets without this hyperlink
appearing all the time. When I go to change an address it takes me
immediately to the web browser and deactivating one at a time is annoying and
sometimes it still doesn't deactivate.
 
G

Gord Dibben

kat

Tools>AutoCorrect Options>Autoformat as you type>Replace as you type.
Uncheck "Internet and network paths with hyperlinks"


Gord Dibben Excel MVP
 
D

David McRitchie

hi katnip,
If you do not have Excel 2002 or later you will have to do
something else. Such as deleting the hyperlinks afterwards with
a macro. You can run a macro to remove hyerlinks from a
selection or you could have an event macro delete the hyperlinks
as soon as they are entered. You can try using Ctrl+Z immediately
after a hyperlink is generated but that will interfere with normal typing
and you will miss some.

Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top