Sub removeAllLinksFromSelection()
Selection.Hyperlinks.Delete
End Sub
If not familiar with macros see David McRitchie's getting started page.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Gord Dibben Excel MVP
On Sun, 2 Jan 2005 04:53:05 -0800, "afglass"
wrote:
In Excel 2000. Is ther a way to remove all hyper links at one time. The
worksheet that I'm using is 674 lines long, and about 1/2 of them have
hyperlinks.