Hiding/Show sheets

[#1]

application  have two sets of sheets in my application and a main menu sheet, with two buttons in main menu.

by default only this main menu sheet should be visible and all others sheets should be hidden.

when I click on one button its associated sheets should highlight and I should have button to got to main menu in all sheets .

when I click on this go to main menu all sheets should be hidden and main menu sheet should be visible.

kindly help me out. \

Please find the attached qvw.

Thanks in advance.

$@M

[amit_saini]

Check attachments.

Thanks,

AS

[#3]

Hi Amit,

I have multiple sheets for a single set , in that case it will not work.

[ecolomer · Accepted solution]

I this you need?

[amit_saini]

Samapth,

The best solution in this cases it to play will variables . Create 2 variable

For example :

vShow =1

vHide=0

and assign these variables to you sheets accordingly. After that create two buttons to Show and Hide all these sheets.

Hope this will help!

Thanks,
AS

[sasikanth]

Hi sampath,

by setting a variable action will resolve your problem,

please find the attached file

[Anonymous]

Hi,

PFA.

Hope it helps.

Thanks,

Nisha loganathan

[#8]

what you have given works for me but there is a small change in it . i.e

when I click on set1 main sheet should be hidden and we should navigate to sheet1 and sheet2 and sheet3 will be active.

like wise for set2 also.

Thanks in advance.     

[Anonymous]

Hi

PFA updated one.

Thanks,

Nisha loganathan.

[sasikanth]

set another variable and

write in lay out condition of main page like in the qvw file