Hyperlink to open hidden worksheets

[majedix]

I have a workbook with many work sheets. My main sheet (called Last 10 days reports) has links to other sheets.
I would like to hide all sheets except the main sheet (Last 10 days reports) when the user opens the file. When the user clicks on any hyperlink to any worksheet.

Main Sheet (Last 10 days reports)
Sheets to be hidden (Sept13 report) and sheet (Sept14 report )and so on..


Best Regards,

 

[wigi]

Then my post # 7 will tell you what to do.

 

[majedix]

Then my post # 7 will tell you what to do.

Appreciated its work well now however, i want this sheet return hide when i go back to the main sheet.

Thanks for your usual help.

 

[wigi]

Then use a Shape linked to a macro, which contains code to hide the page again.

 

[majedix]

Then use a Shape linked to a macro, which contains code to hide the page again.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Worksheets("Last 7 days reports").Select
Target.Parent.Worksheet.Visible = False
End Sub



i have used this code and work perfect. once i click in the back cells in transfer me in the main sheet " Last 7 days report" but, if i click by mouse in the sheet bar over sheet " Last 7 days reports " the sheets that shall be hidden doesn't go still so every time shall i click the back cell to be hide...

Is there any code can i use it to slove this ..


thanks alot.

 

[wigi]

Have a look at the Worksheet_Deactivate and Worksheet_Activate event codes.
They will allow you to run code such as hiding a sheet.

 

[wigi]

See this topic as well:
http://www.mrexcel.com/forum/excel-questions/731363-hide-sheets-click-button.html

 

[justr8hr]

Hello Wigi,

I tried your code but, I am wondering why its not working on mine.
My case is like that of Majedix...My Sheet 1, I named it "Menu" supposed to work like a dashboard. Maybe 30-40 files are hidden which needed a hyperlink.

I dont have problem with shapes because I use macro on it..sweet!

My concern is the hyperlinks to hidden sheet...IT DOESN'T WORK... I even used the podcast of Mr. Jellen on Youtube and it still doesn't work!

I pasted your codes to the VBA (ALT F11), double clicking sheet 1(Menu), then on the top selecting Worksheet. And it still doesn't work.

Here is the png link to my dashboard. I encircled with blue/red the hidden files that should fire up when these hyperlinks are clicked.


https://app.box.com/s/0yusya55kn6iorbjfz7v

Please help me, too. Is there a way to tweak your code so it would work on mine

Thanks a lot!