Hyperlink
 

Is it possible to hyperlink to a hidden worksheet?

Hyperlink
 

I don't think so - if you could, then where would your cursor be?

Pete

On Aug 1, 7:45*pm, Danielle
wrote:
Is it possible to hyperlink to a hidden worksheet?

Hyperlink to hidden worksheet
 

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:

On Friday, August 01, 2008 2:45 PM
Daniell wrote:

Hyperlink
Is it possible to hyperlink to a hidden worksheet?

On Saturday, August 02, 2008 11:06 AM
Pete_UK wrote:

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?

Pete

wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Custom Validation Using the Enterprise Library
http://www.eggheadcafe.com/tutorials...ation-usi.aspx