I've put hyperlinks in cells via VBA like this.
wksErrorPage.Hyperlinks.Add wksErrorPage.Cells(iRowOnErrorSheet, 4), "", wksDetails.Name & "!" + strErrorCell1
Although the hyperlink is actually there, and clickable
It's not visible in the cell
Cannot make visible by applying a color (but can apply background color to the cell)
It doesn't appear in the Formula Bar (and yes, the cell is not formatted ;;;)
Sometimes it is normal! Sometimes not!
Is there a scenario where this could happen?