how to remove hyperlink for the entire worksheet?

  • Thread starter Thread starter Removal of Hyperlinks
  • Start date Start date
R

Removal of Hyperlinks

I am using Excel 2000 and hyperlink has become a nuisance which I don't need.
Whenever I edit a cell, it goes to Windows Live Messenger. How do I remove
the hyperlinks for the entire worksheet?

I could not make the VB Macro work as mentioned in this forum somewhere else.

Thanks.

Nachi
 
Sub RemoveALLHyperlinks()
Dim hHyper As Hyperlink
Dim ws As Worksheet

For Each ws In Worksheets
For Each hHyper In ws.Hyperlinks
hHyper.Delete
Next hHyper
Next ws

End Sub
 
Back
Top