View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
zz zz is offline
external usenet poster
 
Posts: 32
Default Ghost Links - Remove via VBA?

this should do the job


Private Sub deletelinks()
Application.ActiveSheet.Hyperlinks.Delete
End Sub


--
hope this help.
---
zz [MX]
cuasi-musico,semi-poeta y loco


wrote in message
oups.com...
hi there

i havea new workbook copied from an 'older' one.

I want to remove all the links from the new one
i have tried 'breaklinks' through the edit menu
i have tried findlinks.xla - which works great, but i cannot use it
through vba??

any ideas?