Hyperlink.ScreenTip (Excel)
Returns or sets the ScreenTip text for the specified hyperlink.
After the document has been saved to a webpage, the ScreenTip text may appear (for example) when the mouse pointer is positioned over the hyperlink while the document is being viewed in a web browser. Some web browsers may not support ScreenTips.
ActiveSheet.Hyperlinks(1).ScreenTip = "Return to the home page"