Hyperlinks

[chandrashekar]

Hi,

How to remove hyperlinks related to objects?

Thanks in advance.

Regards

Chandra Shekar B

 

[Krishnakumar]

Hi,

Try

Sub kTest()
    
    Dim shp As Object
    
    On Error Resume Next
    For Each shp In ActiveSheet.Shapes
        shp.Hyperlink.Delete
    Next
    On Error GoTo 0
    
End Sub

 

[chandrashekar]

Thank u very much