remove all Hyperlinks at one time.

[Guest]

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.

 

[Don Guillett]

not too hard

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

 

[Gord Dibben]

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