Removing hyperlink without removing the font settings /border sett
Another way:
Sub hyper_be_gone()
For Each r In ActiveSheet.UsedRange
If r.Hyperlinks.Count 0 Then
r.ClearContents
End If
Next
End Sub
--
Gary''s Student - gsnu200747
"San" wrote:
The below code removes hyperlinks
Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub
However it also removes the formatting(color/border) of the cell .
Any idea on how to protect the format of the cell
|