I have a file that has formula hyperlinks... =hyperlink(blah, blah, blah). To make these seem more like hyperlinks, I have highlighted those cells and given them the "Hyperlink Font style" (home ribbon / Styles). This works great. When a user clicks on a hyperlink, it takes them to the location desired and changes the font from a blue to more of a purple as expected.
The problem is, when a user changes some conditions on the page, the cell with the hyperlink will display new information. For instance, if they change the condition "Employee" from Joe to Mike, new data shows in the results below (index / aggregate lookups). This new information is not information they have clicked on, but the cell retains the format as if they had already clicked on that cell. How can I reset the hyperlink format of a cell using VBA or formulas back to blue or unclicked?
The only solution I have come up with is removing the formats and recreating them... is there a way to tell excel to reset the history to unclicked?
Thanks,
Codeninja.
The problem is, when a user changes some conditions on the page, the cell with the hyperlink will display new information. For instance, if they change the condition "Employee" from Joe to Mike, new data shows in the results below (index / aggregate lookups). This new information is not information they have clicked on, but the cell retains the format as if they had already clicked on that cell. How can I reset the hyperlink format of a cell using VBA or formulas back to blue or unclicked?
The only solution I have come up with is removing the formats and recreating them... is there a way to tell excel to reset the history to unclicked?
Thanks,
Codeninja.
