View Single Post
  #3  
Old April 27th, 2010, 05:51 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default how to remove hyperlink for the entire worksheet?

This works in 2003

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Removal of Hyperlinks" Removal of

wrote in message ...
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