+ Reply to Thread
Results 1 to 3 of 3

Is there any VBA code to break the external and Internal links

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    221

    Is there any VBA code to break the external and Internal links

    Hellol friends,

    I have excel workbook which contains many worksheets.

    Each sheet contains internal and external formula links.

    Is there any VBA code which can break the following links of the selected worksheets.
    1. External links since the file is protected and can not break the links by edit links -> break links.
    2. Internal links of other worksheets.

    Please assist.

  2. #2
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    104

    Re: Is there any VBA code to break the external and Internal links

    The below mentioned code is for only Break External links

    Sub BExternalLinks()

    Dim ExternalLinks As Variant
    Dim wb As Workbook
    Dim x As Long

    Set wb = ActiveWorkbook


    ExternalLinks = wb.LinkSources(Type:=xlLinkTypeExcelLinks)


    For x = 1 To UBound(ExternalLinks)
    wb.BreakLink name:=ExternalLinks(x), Type:=xlLinkTypeExcelLinks
    Next x

    End Sub

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    221

    Re: Is there any VBA code to break the external and Internal links

    Dear Chandy,

    Thanks. But its not serving my purpose.
    VBA breaks links in the whole workbook. I need to remove the link in a particular worksheet.

    Please assist.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Break External Data Links - Error Runtime 13
    By brainzlp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2016, 12:52 PM
  2. Break Internal Worksheet links in a file
    By lalaarif1 in forum Excel General
    Replies: 1
    Last Post: 10-11-2015, 03:16 PM
  3. Break internal and external links of selected tabs.
    By lalaarif1 in forum Excel General
    Replies: 1
    Last Post: 05-17-2015, 05:47 AM
  4. [SOLVED] Update and then break external links to another workbook
    By tatiana_ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2014, 03:22 AM
  5. Completely remove/delete all the external links (Break Links)
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 05:31 AM
  6. Break external Links
    By pauluk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2007, 11:11 AM
  7. Convert external links to internal
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2006, 11:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1