PDA

View Full Version : [SOLVED] Can you hyperlink to a hidden sheet?



kane
05-19-2005, 02:37 PM
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
05-19-2005, 04:02 PM
Is this solved?

johnske
05-19-2005, 04:08 PM
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
05-19-2005, 04:39 PM
Or try the attached

kane
05-19-2005, 05:14 PM
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?