Ghost Links - Remove via VBA?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pennie.thomas@ace-ina.com - 03 Nov 2006 10:30 GMT

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?

Reply to this Message

zz - 22 Nov 2006 18:29 GMT

this should do the job

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

Signature

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

> hi there
>
[quoted text clipped - 6 lines]
>
> any ideas?

Reply to this Message