Stop Excel from adding hyperlinks...

[Frank McMahon]

Everytime I paste an e-mail into Excel 2002 it makes it a hot link, I just
want it as text. Any way to stop this?

Also...how can I eliminate the links, e-mail, web, from an entire column?

Thanks!

Frank

 

[David McRitchie]

Hi Frank,
Since you have Excel 2002 you can actually prevent the links from
being created under the Auto Correct from the Tools menu.
Tools (menu), Autocorrect Options, Autoformat as you type (Tab).

For previous versions the simplest is to just let them be created and
remove them with the same macro you would use to remove your
existing hyperlinks. The other way prior to Excel 2002 is rather round
about and involves using an event macro to remove

To remove the existing links, but not if Hyperlink Worksheet Function,
you can make a selection such as an entire column in your case with
a macro. To install use macro see my getstarted.htm webpage.

Sub DelHyperLinks()
Selection.Hyperlinks.Delete
End Sub