Can you hyperlink to a hidden sheet?

[kane]

Can you hyperlink to a veryhidden worksheet?

I have a hyperlink on sheet 1 that links to a veryhidden sheet 2.
How do I get sheet 2 to become visible and the active sheet?

I have a hyperlink on sheet 2 that refers back to sheet 1.
How do I go back to sheet 1 and make sheet 2 veryhidden again?

[mdmackillop]

Is this solved?

[johnske]

Hi Kane,

If you've solved this, fine, but for the benefit of others who may also be wondering, you can use this:


Option Explicit
'code for sheet2 module
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheet2.Visible = xlSheetVeryHidden
End Sub

Option Explicit
'code for sheet1 module
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheet2.Visible = xlSheetVisible
End Sub


Regards,
John

[mdmackillop]

Or try the attached

[kane]

Ok, another problem.

I've got several hyperlinks on worksheet"Main" all refering to their own pages.
How do I get the "production" hyperlink to goto the "production" worksheet and make it the only visible worksheet?