Hi

I would try this macro to delete any hyperlink
Sub DisplayName()
Dim n As Name
For Each n In ThisWorkbook.Names
With n
If MsgBox("Delete " & .Name & " ? " & vbCrLf & _
"Refers to " & .RefersTo, vbYesNo + vbQuestion) Then .Delete
End If
End Su

--
jette
-----------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...fo&userid=1753
View this thread: http://www.excelforum.com/showthread.php?threadid=57314