Removing hyperlinks from multiple images

[JacksonTriggs]

Hi,

I have a spreadsheet with multiple logos in a single column, each of which have a single hyperlink. I'm trying to remove the links. However, when I select all images, the "Remove Hyperlink" option is greyed out. I cannot find any previous forum posts on this issue.

Please help? Thanks in advance!

 

[GWteB]

This macro does what you want. It's targetting the active worksheet.

Sub ShapeHyperlinkDelete()
    Dim shp As Shape
    For Each shp In ActiveSheet.Shapes
        On Error Resume Next
        shp.Hyperlink.Delete
    Next
End Sub

 

[EXCEL MAX]

One more option...
I don't think so it's possible without VBA.
With right click select images from which you want to remove hyperlinks or select all images and run this code...

Sub RemoveSelectedHyperlinks()
    
    On Error Resume Next
    With ActiveSheet
        For vN = 1 To Selection.ShapeRange.Count
            .Shapes(Selection.ShapeRange.Item(vN).Name). _
             Hyperlink.Delete
        Next vN
    End With
    
End Sub

 

[JacksonTriggs]

This macro does what you want. It's targetting the active worksheet.

Sub ShapeHyperlinkDelete()
    Dim shp As Shape
    For Each shp In ActiveSheet.Shapes
        On Error Resume Next
        shp.Hyperlink.Delete
    Next
End Sub

It worked perfectly. I should clarify this macro removes hyperlinks from images (shapes) yet not hyperlinks associated with text. Exactly what I wanted. Thank you so much (again)!

 

[GWteB]

You're welcome & thanks for the feedback.

 

[JacksonTriggs]

One more option...
I don't think so it's possible without VBA.
With right click select images from which you want to remove hyperlinks or select all images and run this code...

Sub RemoveSelectedHyperlinks()
   
    On Error Resume Next
    With ActiveSheet
        For vN = 1 To Selection.ShapeRange.Count
            .Shapes(Selection.ShapeRange.Item(vN).Name). _
             Hyperlink.Delete
        Next vN
    End With
   
End Sub

Thank you Excel Max! It worked perfectly. The only difference from GWteB's macro is, and as you mentioned, it works for images that are selected. Very helpful when needing to remove hyperlinks from some of the images. Again, much appreciated!