Hyperlink.TextToDisplay (Excel)

Returns or sets the text to be displayed for the specified hyperlink. The default value is the address of the hyperlink.

ActiveSheet.Hyperlinks(1).TextToDisplay = _ 
 "Company Home Page"