![]() ![]() ' Break all links in the active workbook.įor lLink = LBound(vLinks) To UBound(vLinks) VLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks) Here's the BreakLinks procedure : Sub BreakLinks() I got some VBA code to cleanly break Excel links in Excel 2010, however the trouble I always have is that Excel will prompt me every time I RECREATE the link. ![]() ![]() I'm trying to programmatically break all links, then recreate them in a workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |