Deactivating hyperlinks

D

Denny

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

Thanks
 
K

Ken Wright

Put the following into a code module and run it.

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