+ Reply to Thread
Results 1 to 2 of 2

remove hyperlinks from objects in the excel workbook using vb

Hybrid View

  1. #1
    Registered User
    Join Date
    07-13-2005
    Posts
    2

    remove hyperlinks from objects in the excel workbook using vb

    hi
    i am trying to remove hyperlinks that are linked to objects in the excel workbook using vb.
    the code that i am using is as follows:

    If wSheet.Hyperlinks(i).Type <> 0 Then
    wSheet.Hyperlinks(i).Delete
    ObjExcel.Save
    hashyperlinks = True
    End If

    this code does not remove hyperlinks from the organizational charts, flow charts, cycle diagrams, etc. it just removes hyperlinks from the images
    can some1 pls help.

    thanks in advance

  2. #2
    Registered User
    Join Date
    08-20-2003
    Location
    Luton, England
    Posts
    63
    The code below removes all hyperlinks in a worksheet.
    To remove special types re-enable the commented out lines and amend as necessary.
    Sub untested()
        ' Hyperlink types:   
        'oHyperlinkInlineShape, msoHyperlinkRange, msoHyperlinkShape.
       '---------------------------------------------------------------------------------
        For Each h In ActiveSheet.Hyperlink
            'If h.Type = "??" Then
                h.Delete
            'End If
        Next
    End Sub
    Regards
    BrianB
    Most problems are caused by starting from the wrong place.
    Use a cup of coffee to speed up all Windows processes.
    It's easy until you know how.
    -----------------------------------------

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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