I would like to disable the Filepath information from displaying when you hover over a hyperlink.
I'm creating these hyperlinks via VBA and I'm hoping there is some value that I can set to prevent the filepath from appearing when you hover over the hyperlink.
Please see the attached screen shot.
Here is the code I am using to create the hyperlink. "Destination" is string that is a named range with refers to Cell A1 on different sheets.
With Me
.Hyperlinks.Add Anchor:=Range(Target.Address), Address:="", SubAddress:=(Destination), _
TextToDisplay:="", _
ScreenTip:=""
Target.Style = "Hyperlink"
End With
Bookmarks