View Single Post
  #3   Report Post  
Old April 27th 10, 05:51 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
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