BreakLink does not seem to work

Question

I'm trying to remove link in Excel 2010 that had been created by copying ranges from other workbooks using the following lines of code in VBA.

For some reason the links to not get removed and remain. No error message, but no success either.

Interestingly, when I try to break the link using the Excel user interface, they also remain.

Any ideas what I'm doing wrong?

vLinks = gxlbTarget.LinkSources(xlLinkTypeExcelLinks)
For Each strLink In vLinks
    gxlbTarget.BreakLink name:=strLink, Type:=xlLinkTypeExcelLinks
Next strLink

Answer 1

Works for me...  maybe your workbook or worksheet is protected?

---

HTH, Bernie