how to remove hyperlink for the entire worksheet?

  • Thread starter Removal of Hyperlinks
  • 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
 
O

ozgrid.com

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
 
D

Don Guillett

This works in 2003

Sub nohyperlinks()
ActiveSheet.Cells.Hyperlinks.Delete
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top