Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Removing Hyperlinks (Excel 2002)

    Is there any way to remove hyperlinks from more than one cell at a time? I import a large list into Excel, and one whole column consists of hyperlinks. I can remove the links one at a time, but I discovered that if I select more than one cell the Edit Hyperlink option no longer includes the "Remove Hyperlink" option.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Removing Hyperlinks (Excel 2002)

    Select a blank cell and copy it. With Excel in Copy mode select all the hyperlink cells to operate on. Then select Edit, Paste Special, Add, OK, Esc.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Removing Hyperlinks (Excel 2002)

    John's suggestion is much simpler!

    The following simple macro will remove all hyperlinks from the selected range:

    Sub RemoveHyperlinks()
    Dim oCell As Range
    For Each oCell In Selection
    oCell.Hyperlinks.Delete
    Next oCell
    Set oCell = Nothing
    End Sub

    If you need to do this often, put this procedure in a module in your Personal.xls and assign it to a custom toolbar button or keyboard shortcut.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Removing Hyperlinks (Excel 2002)

    You could run a simpe macro. This will delete all the hyperlinks on the sheet or in a selection

    This will delete all the hyperlinks in the sheet
    <pre>Sub DeleteHyperlinksSheet()
    Dim hl As Hyperlink
    For Each hl In ActiveSheet.Hyperlinks
    hl.Delete
    Next
    End Sub</pre>


    This will delete all the hyperlinks in the selected cells
    <pre>Sub DeleteHyperlinksSelection()
    Dim hl As Hyperlink
    Dim rcell As Range
    For Each rcell In Selection
    For Each hl In rcell.Hyperlinks
    hl.Delete
    Next
    Next
    End Sub</pre>


    Steve

  5. #5
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Removing Hyperlinks (Excel 2002)

    Thanks to everyone -- I think that a macro will do the trick.

Posting Permissions

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