I supposedly have a link in a workbook to an excel file which doesnt even exist, and i cannot remove it. i click break link and it does nothing. i have done a find within the workbook looking for the text within the link, ive run:
ActiveSheet.Hyperlinks.Delete
and
Sub breakLinkedWorkbooks()
Dim Links As Variant
Links = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(Links) Then
For i = 1 To UBound(Links)
ActiveWorkbook.BreakLink Name:=Links(i), Type:=xlExcelLinks
Next i
End If
End Sub
and *STILL* the bluddy link remains!! none of the 3 worksheets are protected, the workbook is not protected and there are no hidden sheets.
any ideas?
Bookmarks