Deactivating hyperlinks

[Denny]

How can hyperlinks be automatically deactivated in a
column in Excel 2000?

Thanks

 

[Ken Wright]

Put the following into a code module and run it.

Sub RemoveHyperlinks()
On Error Resume Next
Selection.Hyperlinks.Delete
End Sub