You need to specify TextToDisplay ActiveSheet.Hyperlinks.Add Anchor:=Range("e" & i), Address:=Str, TextToDisplay:=pn & ".pdf". Sometimes ...Excel VBA code for long url to hyperlink with display ...1 answer
DOWNLOAD: https://byltly.com/2eucnr
DOWNLOAD: https://byltly.com/2eucnr
excel-vba-hyperlink-text-to-display
Hyperlinks.Add Anchor:=Sheets("sub").Range("A1"), Address:="https://www.educba.com/", SubAddress:="", ScreenTip:="it is a Hyperlink", TextToDisplay:="Excel .... Dec 13, 2010 — That's the text you can see in the cell with the hyperlink, like "Sales Report" in ... for that in Excel, but you can create your own, with a bit of VBA. 3925e8d270
Comments