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?
Last edited by mdmackillop; 05-20-2005 at 12:05 AM. Reason: Removing "Solved" status
Is this solved?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Or try the attached
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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?
Posting Permissions
Reply With Quote
