disable auto-creation of email hyperlink?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I enter a string of text that contains the @ symbol, Excel automatically turns it into a hyperlink to my email program. Is there a way to disable this?
 
Hi Joan,

depends on your Excel version:
Excel 2003: Goto 'Tools - Autocorrect - Auto format as you type' and
disable this option

Before that (though as I don't use Excel 2002 maybe the tip for Excel
2003 will work):
a) Use the following macro to remove hyperlinks of a chosen selection
(after your data entry)
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub

b) Without macro:
- Type the number 1 in a blank cell and copy this cell
- Select all your cells with hyperlinks
- goto 'Edit - Paste Special'
- choose multiply

c) Process the Worksheet_change event (see
http://www.mcgimpsey.com/excel/nohyperlinks2.html)

HTH
Frank
 
Joan

Tools>AutoCorrect>Autoformat as you type> uncheck "internet and network paths
with hyperlinks"

Gord Dibben Excel MVP
 
Back
Top