How to trigger FollowHyperlink Event in Excel VBA with blank hyperlinks

During a recent project, I just wished to run my Excel VBA app via hyperlinks. VBA has an event "FollowHyperlink" which triggers whenever you click on a hyperlink in your active workbook. But there are two main issues. First, Hyperlink cant be a blank and 2nd, if you provide a valid hyperlink then this event will trigger after url execution. In my case, i only wanted to trap the event without invoking the default browser. I tried to google it for any trick but couldn't found one. Did few experiments and I have finally found a handy way of doing it. :-)

How to remove special characters from Excel cell

Enlarge it to clearly view special character

Whenever you link cell in Excel worksheet to a cell that has multiple lines, you might notice that the linked cell shows text in single line and a tiny suspicious character shows up at the place of line break.