Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a following question. I want to create a button which switches between 2 screens. The both screens are same, just differ by some filter . One screen is main and visible by deafaule in the main menu and the second screen is visible only after pressing on the button and not part of main menu at all. So, How do I do it? Thanks,
Inna.
Hi, each sheet has a "show condition" the button can set a variable value to 1, and set the show condition of the sheet to $(variableName)=1
Hi, each sheet has a "show condition" the button can set a variable value to 1, and set the show condition of the sheet to $(variableName)=1
as suggested by @rubenmarin ,
Create a variable vhidesheet and set it to 1. On the Sheet Properties->General Tab, set conditional and assign the variable vhidesheet. Create a button and add action External->Set Variable. Pick variable vhidesheet. In the value field, type the expression =If(vhidesheet = 1, 0,1) that will hide or display the sheet.