Hi,
I have a worksheet with various links that trigger the link to open the hidden tab.
The code I am using for this is:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
LinkTo = Target.SubAddress
WhereBang = InStr(1, LinkTo, "!")
If WhereBang > 0 Then...