Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My mistake, sorry.
Hi Maria,
check attached example.
Kind regards
Przemek
Sorry I cannot see the attachment!
My mistake, sorry.
Thank you much appedciated
Regards
Maria
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
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
sorry, solved , had to add them all to project varaibles , then works ok