removing and disabling hyperlinks in excel cells??

[cfdh_edmundo]

Hi,

Quick question, I've a sheet with codes that automatically generate hyperlinks in certain cells.

Is there anyway to globally remove and then disable the hyperlinks ?

I realise I can format the cell to take away the blue colouration of the text and the underline, but when I hover the mouse over the cell it is still a hyperlink.

Is there anyway to disable these links.

Any help would be great,

Cheers.

 

[Artorius]

Does using the Clear Contents option in the cell solve the problem?

 

[cfdh_edmundo]

Does using the Clear Contents option in the cell solve the problem?

Hi,

The thing is the text of the hyperlink contains data I want, so its just the linkage I want to remove.

So for instance the cell will display a team's name (like Spurs) and then will link to their website if clicked on (ie goes to www.spurs.co.uk).

I want it to still say "Spurs", but I want the linkage removed.

 

[maytas]

Hi,

Sub DisableHyperlinks()
    Dim Link As Hyperlink
    If ActiveSheet.Hyperlinks.Count > 0 Then
        For Each Link In ActiveSheet.Hyperlinks
            Link.Delete
        Next Link
    End If
End Sub