I need help with Removing hyperlinks!

[K.C.]

I have several excel spreadsheets that are filled with
embedded hyperlinks. Is there a fast way to remove them
all from a worksheet at one time rather than try to delete
them individually? Thank you for your help.

 

[Max]

Try:Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End SubAbove sub is taken from John Walk's:
http://j-walk.com/ss/excel/usertips/tip031.htm

 

[Max]

Sorry about the awful wrap ..

Should read as:

Try:

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub

Above sub is taken from John Walk's:

http://j-walk.com/ss/excel/usertips/tip031.htm

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/nohyperlinks.html

 

[Don Guillett]

another
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub