Hide a sheet

[danialier]

Hello !

Do you know how I can hide a sheet and make it appear when I click on a text box (located in another sheet)  ?

thanks !

dani

[vikasmahajan]

Approach is Take Variable or if you have section access load variable with excel and apply condition as per attached jpg.

Vikas

[#3]

Hello Dani, you have to use a variable.

Declare it in Variable Editor, then use in a sheet a Visibility Condition on that variable, finally manage the variable on text field click.

See attached file for a sample.

Regards,

f.

[bruno_m_santos]

Few steps:

1) Create a variable

Set vShow=0;

2) Then ShhetProperties> General>Conditional, put vShow=1:

3) Create a button, with a trigger >External> Set Variable:

Set Variable "vShow"

value: if(vShow=1, 0,1)

Thanks

Bruno

[richard · Accepted solution]

Sheet B (not to be hidden)

1. Create textbox

2. Create a variable for example called vHideSheetA

3. Go to the actions tab in de textbox properties and add the action type "External" and add the action "Set variable".

4. Fill in the variable name "vHideSheetA" with value 1

Sheet A ( to be hidden)

1. Select the sheet properties

2. Go the the "show sheet part"

3. Fill in this expression example:

vHideSheetA = 0

!!!! Don't forget to make a textbox to show the sheet back! ==> vHideSheetA = 0