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.

not too hard

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

--
Don Guillett
SalesAid Software

"afglass" wrote in message
...
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.

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.