Here the requirement is i have 15 sheets in the dashboard. 10 sheets is belongs to one dashboard and 2 sheets belongs one dashboard and remaining one more dashboard.
When am clicking on "hide tabrow" all the tab are hiding. I don't want to hide all the tabs. I want to hide 14 sheets and 1 sheet need to be displayed. the same way for remaining dashboards.
Please advice if there is a another option where we can hide required sheets.
Thanks in advance.
Refer to the attached is the requirement you want.
When Main1 is clicked, Main2Sheet1 and Main2Sheet2 will appear.
When Main2 is clicked, Main2Sheet1 and Main2Sheet2 will be hidden.
Thanks and regards,
you may use variables for each Dashboard and define Show Sheet (Sheet properties)
conditional vDashboard1 = 1 for showing, etc. (define vDashboard1 to 0 e.g. in document Triggers)
so you may hide the 14 Sheets and only Show 1 sheet
whenever you Need to Show the 14 other Sheets you Need to deine vDashboard1 to 1
same to other dashboards
Thanks for your solution Rudolf,
We tried to do this but little confusion while doing this one. (define vDashboard1 to 0 e.g. in document Triggers).
Can you please provide the more clarity?
you may use a document triggers e.g. on open, define an Action extern, define variable and then define
vDashboard1 set to 0
Only one sheet should be shown. if you want the other 14 Sheets to appear you may use a button and deinfe an Action with vDashboard set to 1
But as Gysbert mentioned, how do you want to Show Dashboard 2 or 3? How do you want to Control the appearance or hiding of Sheets. Doing this with variables is quit easy as I do this very often.
but you Need to know when and how the Sheets must be controlled
If you give more Information I may assist you
Thanks for your help. I tried as per you suggestion. Please find the attached file. Here my dashboard should be Main1 and Main2.
I want to see the two sheets.i.e.,Main1 (hyperlinks are Main1Value1, Main1Value2, Main2Value3. These 3 sheets are under Main1 and i want to hide.) and Main2 the ((hyperlinks are Main2Value2, Main2Value2. These 2 sheets are under Main2 and i want to hide.)
When i creating the variable for hiding sheets ,working perfectly but hyperlinks are not worked.
Please advice. Thanks again.
Excellent. It's working fine.
When i clicked on Main2, then only that current sheet is hiding. Is there any chance to hide that current sheet when am clicking on the Main1/Main2 tabs. Instead of clicking Main1/Main2 Button.
Thanks again for your help.
Not really understand your requirements, but you can refer to the attached below.
When Main2 is clicked, Main1Sheet1 and Main1Sheet2 will be hidden.
Do play around and see if this covers your requirements.