Turn off email formatting in Excel

  • Thread starter Thread starter webempres
  • Start date Start date
W

webempres

Hello - my first post here.

I am using Excel (Office 2K) and every time I type in an email address
it automatically becomes an active link. Is there anyway to shut thi
off?

Thanks,

M'Lis
:confused
 
Not really the link will be created, Excel 2003 has an option.
I think it can be helpful so I'd not want to block it since it is easy
to remove them.

In any version that does this Excel 97 and up.
you can remove them with a macro based on selection see
Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks

Sub DelHyperLinks()
Selection.Hyperlinks.Delete
End Sub

You could use an Event macro to remove them as soon as you type, but
I think you would find it a terrific nuisance including being interrupted while
typing.
 
Hi

tools / autocorrect options / autoformat as you type tab - untick internet &
network paths with hyperlinks.

Cheers
JulieD
 
I meant Excel 2002 and above has an option to turn off which you can
see in JuliaD's reply. But for Excel 2000 you would have to use a
macro as in my prevous reply.
 
Back
Top