I track some information in Excel, and one of the columns is for a link to some location (blogs, Web sites, etc.). One of the things is that I don’t want the URL to appear as it creates display issues (as shown here). I really want it to look like this: I prefer to just display the word “Link” that is marked up with the actual link.
The rest is here:
Excel VBA Cells and Hyperlinks