Thread: Clearing Links
View Single Post
  #5   Report Post  
Connie Martin
 
Posts: n/a
Default

Actually, the very best one is he http://www.mrexcel.com/td0048.html
Just download the file: http://www.herber.de/andere/findlink.zip found
part way down the page.

"ancasa" wrote:


no problem....the solutions.

copy the code in an module to vb in excel and o.k. then run macros
zaphyperlinks

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub


Best regards

Andy


--
ancasa
------------------------------------------------------------------------
ancasa's Profile: http://www.excelforum.com/member.php...o&userid=23862
View this thread: http://www.excelforum.com/showthread...hreadid=377072