Show and hide sheets

[arethaking]

Hi All,

I have 3 sheets with Sheet1,Sheet2,Sheet3.

My requirement is Sheet1 is always should be active.

remaining should be shown based on selection.

If Sheet2 is active, sheet3 should be hidden.

If Sheet3 is active, sheet2 should be hidden.

Please advise.

[Frank_Hartmann]

see attached file.

hope this helps!

[arethaking]

Hi franky_h79

By default I want to show Sheet1.

Sheet2 to Sheet3 is not working.

Please help.

[arethaking]

I am trying with this but unable to fix it.

[vardhancse]

Hi,

1. Create on open trigger to open sheet 1 by default.

2. In sheet1->text object->Action->to open sheet2

3. In sheet2->text object->Action->to open sheet2

4. Settings->Documents Properties->Hide Tab Row

PFA attached QVW

[arethaking]

Hi vardhancse

Thank you for the solution. I want to show always first sheet. How to show?

[jyothish8807]

Hi Aretha,

Is this what you are looking for?

Br,

KC

[Frank_Hartmann]

As far as I understood your requirement when opening the app all the sheets should be displayed. When I open sheet 2, sheet1 remains and sheet 3 disappears. When I openon sheet 3, sheet1 remains and sheet 2 disappears.

So this is not your requirement?

then please describe your requirement in more detail, because my sample shows exactly what you were asking above.

[vardhancse]

HI.

1. Create on open trigger to open sheet 1 by default.

settings->documents & Settings->Triggers->On Open->Add Action

Add->Layout->Activate sheet->SH01

SH01= [Sheet ID]

[#10]

Hi,

I will give you a basic and easy idea to solve this.

1. Create three sheets SHEET1, SHEET2 and SHEET3. Declare a variable vDisplay

2. Create two buttons SHEET2 and SHEET3 in the SHEET1

3. Go to SHEET2(Button Properties) >>> Action >>> External >>> Set Variable >>> vDisplay >>> Value=0

4. Go to SHEET3(Button Properties) >>> Action >>> External >>> Set Variable >>> vDisplay >>> Value=1

4. Go to Sheet Properties of Sheet2 and in Show Sheet tab give the Condition as vDisplay=0

5. Go to Sheet Properties of Sheet3 and in Show Sheet tab give the Condition as vDisplay=1

Your requirement has been met. Kindly notify for further clarification.