How to remove all hyperlinks from a worksheet in Excel?

[Amos]

I have many HyperLinks on one of my worksheets, which I want to remove them
all. I'm sure EXCEL has a single command to do this but I can't find it!
Please help.
Regards - Amos ([email protected])

 

[Nick Hodge]

Amos

This code in a standard module will delete all hyperlinks on the activesheet

You might want to add it to your personal.xls if you use it often

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Dave Peterson]

And I bet that code looks something like this:

Option Explicit
sub RemoveHyperLinks
activesheet.cells.hyperlinks.delete
end sub

 

[Nick Hodge]

Dave

Ooops...now is it still on the clipboard ;-)

Sub DeleteHyperlinks()
Cells.HyperLinks.Delete
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)