Deleting Hyperlinks

[Bonnie]

I know you can delete (de-activate) a hyperlink by right
clicking, going to hyperlink, and remove hyperlink.
This is a one by one process.

How can I delete hyperlinks in the entire spreadsheet?

Thanks
Bonnie

 

[Frank Kabel]

Hi
see
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

several macros for dealing with hyperlinks

 

[Don Guillett]

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