Hide worksheet until called out thru hyperlink?

cherrydee

New Member
Joined
Jan 1, 2017
Messages
13
Hi guys. Just wonderin if there is any way to unhide a worksheet upon being clicked thru a hyperlink? My workbook almost contain 20 worksheet now and I'm planning to create a neat dashboard where certain buttons will go to respective worksheet. So my options are: 1. Hide all worksheets except dashboard then after clicking the link, the sheet will be unhide.
2. If it's too complex then maybe I'll just opt to use the back button
Thanks guys!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
What exactly do you mean by 'unhide'? You can hide all tabs and create navigation between sheets using hyperlinks and buttons if you want to.
 
Upvote 0
Why not use a button to unhide the sheet.
Links cannot unhide sheets.
 
Upvote 0
Sorry for being vague. Let's assume i have 10 worksheets. 1 of which will be my dashboard containing buttons that are hyperlinked to the other 9 sheets. I would like to hide the 9 sheets and whenever i click a link in the dashboard, that sheet will unhide. Then automatically hide again after navigating to other sheets. My goal here is to make my workbook neat in terms of navigating thru different tabs. Its hard to navigate if i have almost 20 tabs and the tab names are kinda long
 
Upvote 0
Like I said before:
You cannot hyperlink buttons to sheets.

You said:" i have 10 worksheets. 1 of which will be my dashboard containing buttons that are hyperlinked to the other 9 sheets."


Maybe your not familiar with Macros and how they work.

If you want a button to perform some sort of action you put a Macro script in the button and when you click on the button some action takes place.

Why you keep insisting you can create a hyperlink to hide sheets is beyond me. If you know how to do this please tell me how.


If you want a button which when clicked on will hide sheet (3) for example you need a script like this:


Code:
Sheets(3).Visible = False



Right click on your button. Choose "Assign Macro" and paste in this code.

Now when you click on the button sheet(3) will be hidden

Now if this is what you want explain more about what you want in total.

And you need to explain what type button your using.

When asking for help here you need to give specific details.

There are shape buttons, Activex command buttons, and Form control buttons.

And your Workbook will need to be saved as Macro Enabled.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top