L Lam Roy Feb 26, 2010 #3 Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Worksheets(Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)).Visible = xlSheetVisible Application.EnableEvents = False Target.Follow Application.EnableEvents = True End Sub Daniell wrote: Hyperlink 01-Aug-08 Is it possible to hyperlink to a hidden worksheet? Previous Posts In This Thread: Hyperlink Is it possible to hyperlink to a hidden worksheet? I don't think so - if you could, then where would your cursor be? I do not think so - if you could, then where would your cursor be Pet wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Custom Validation Using the Enterprise Library http://www.eggheadcafe.com/tutorial...c-33ef1ec7d1a3/wpf-custom-validation-usi.aspx
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Worksheets(Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)).Visible = xlSheetVisible Application.EnableEvents = False Target.Follow Application.EnableEvents = True End Sub Daniell wrote: Hyperlink 01-Aug-08 Is it possible to hyperlink to a hidden worksheet? Previous Posts In This Thread: Hyperlink Is it possible to hyperlink to a hidden worksheet? I don't think so - if you could, then where would your cursor be? I do not think so - if you could, then where would your cursor be Pet wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Custom Validation Using the Enterprise Library http://www.eggheadcafe.com/tutorial...c-33ef1ec7d1a3/wpf-custom-validation-usi.aspx
