SHEETS HIDE AND SHOW

[#1]

I have 3 Sheets labeled Sheet1, Sheet2 and Sheet 3.   ON Each Sheet I have 3 buttons, each button is Called as

Sheet1, Sheet2 and Sheet 3. SO when I click on Sheet1, it shows only Sheet1 and hide the other sheets, or if I select Sheet2, it shows, Sheet 2 only and Hide the others. How can I do that

[mayankraoka]

Hi ,

You can go on action and select activate sheet (add-action type -layout)and give the sheet id number over there..

Regards,

Mayank

[miguelbraga]

Hi Rehan,

Make 3 variables (vTab1, vTab2, vTab3) and in the Sheet Properties check the Conditional and add this expression:

For Sheet 1:

=vTab1='Yes'

For Sheet 2:

=vTab2='Yes'

For Sheet 3:

=vTab3='Yes'

Button 1:

Set Variable

Variable>vTab1;

Value>=if(vTab1='Yes', 'No', 'Yes')

Variable>vTab2

Value> =if(vTab1='Yes', 'No', 'Yes')

Variable>vTab3

Value> =if(vTab1='Yes', 'No', 'Yes')

Button 2:

Set Variable

Variable>vTab2;

Value>=if(vTab2='Yes', 'No', 'Yes')

Variable>vTab1

Value> =if(vTab2='Yes', 'No', 'Yes')

Variable>vTab3

Value> =if(vTab2='Yes', 'No', 'Yes')

Button 3:

Set Variable

Variable>vTab3;

Value>=if(vTab3='Yes', 'No', 'Yes')

Variable>vTab2

Value> =if(vTab3='Yes', 'No', 'Yes')

Variable>vTab1

Value> =if(vTab3='Yes', 'No', 'Yes')

This can and should do the trick

[varunreddy]

Take a variable vbutton.

For Sheet1 - Go to sheet properties- general - conditional enabling - vButton =1.

For button sheet1 - use an action - external - setvariable - (variable - vbutton  and value = 1)

For Sheet2 - Go to sheet properties- general - conditional enabling - vButton =2

For button sheet2 - use an action - external - setvariable - (variable - vbutton  and value = 2)

For Sheet3 - Go to sheet properties- general - conditional enabling - vButton =3.

For button sheet3 - use an action - external - setvariable - (variable - vbutton  and value = 3)

This should work. It is working fine to me

Regards,

Varun

[#5]

It didnt work, it HIDES ALL THE SHEET AS u click on each button

[#6]

It didnt work for me, can you please attach a qvw?

[varunreddy]

[#8]

Pls attach a qvw , I did the same thing

[varunreddy]

Can you guide me how to insert QVW?

I dont see any option. I will post it

[mayankraoka]

Hi Varun,

May be you are having personal edition.

Regards,

Mayank