Hiding/Showing Sheets

[#1]

For a number of sheets in my model I want to hide the sheets when they are inactive.  I have tried the conditional 1=2 for the sheet and can hide them. However I have not been able to get the sheets to open again unless I go into the Document Properties. Ideally I would like to use a button on my main sheet to open and activate some of these hidden sheets. Please can anyone point me in the right direction, regards Maria 

[#2]

Hi Maria,

check attached example.

Kind regards

Przemek

[#3]

Sorry I cannot see the attachment!

[#4 · Accepted solution]

My mistake, sorry.

[#5]

Thank you much appedciated

Regards

Maria

[jack]

did download the demo, but when adding to my set , can't get de the variable  vShow active

what do i wrong???

thanks for advise

[jack]

ok thas solved by ctrl alt V

but i have 3 sheets,  so if want to toggle from dashbord i did create a vShow2 and vShow3  and added

to variables,  then create in dashboard a action like vShow2=0,1,0  and vShow3=0,1,0 

that did not work

please advise,  thanks

[jack]

sorry, solved ,  had to add them all to project varaibles ,  then works ok