how to hide the sheets after linking them with buttons??

[#1]

Hi all,

I have an issue with linking the buttons to particular sheets in my file.I have linked them but I want to hind the unwanted sheets when their corresponding buttons are not clicked.

if you see my file:

when I click buttons A/B it should show sheets A and B but not C and when I click on C it should show me only C .the main tab should always be present.I am stuck up in doing this,can anyone help me out??

regards,

Sahana

[tresesco]

Use trigger to set variable and use that variable in the conditional display expression like in attached qvw.

[#3]

Hi tresesco,

thanks for the response.

IF I want to display both the sheets A and B for botton A then how could I do this??

[SunilChauhan]

set variable to same value ,

i mean in general of both sheet  set variable =1 on btutton click

[#5 · Accepted solution]

Create buttons and  a variable vShow

Then on Button A set an action as

External-->Set Variable

Variable : vShow

Value : 1

goto sheet1/sheet2

set conditional diaply

vShow=1

[#6]

Thanks a lot all for your valuable help.

[#7]

You are Welcome..

[SunilChauhan]

just the way of describing matters here