I have been trying to easily hyperlink to a chart sheet and have found a simple solution but would like to simplify it further for future use.

Right now I am using:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheets(Target.TextToDisplay).Select
End Sub

(Note: the link location doesn't matter)
Now when I create a hyperlink using the create hyperlink function and set the Text to Display as the chart sheet name this works.
However when I use a formula and set the [friendly_name] to the same value as I would enter into Text to Display the marco does not work.

If anyone knows the difference between [friendly_name] & Text to Display or has an easy alternative solution I would be very appreciative.