Format cell

[gustaf111]

Hello, I try to change a cell that got a hyperlink to display black text and not the hyperlink blue with vba ... but how ?

If I change the format to text, the hyperlink is still in blue ...

 

[Jonmo1]

change the actual text formatting, Font, Color, Underline, etc..

 

[gustaf111]

I got a hyperlink but if the cell got empty I would like to display just text and not a hyperlink, so somehow I suppouse I need to format that cell ...

 

[Jonmo1]

Perhaps right click the cell - remove hyperlink

 

[gustaf111]

Thanks!