Dear All

I have a Hyperlink which appears in a cell as a result of an IF statement in that cell. Is there a way of either suppressing or changing the text in the Screen Tip box so that it does not show the path to the link location on hover ?

Also is there a way of being able to follow the link without having the cell unlocked on a protected sheet ?

Any help much appreciated