Hide and Un hide Sheets with selection.

[#1]

Hi All,

I have straight table i want to open a new sheet when i click on the item.

When i click on specific item i need to open new tab according selection.

Thanks & Regards

[#2 · Accepted solution]

Hi,

Try to check attached file

[Roop]

Under Sheet Properties:

Check the conditional radio button and add the code:

vHiddenMain = 'N'

Create a variable called vHiddenMain

Create a button with "Unhide":

Set variable vHiddenMain to 'N'

Create a button with "Hide":

Set variable vHiddenMain to 'Y'

See attached

[mukesh24]

Hi Vamsi,

create field event trigger as -->

In Setting Tab --> Document Properties --> Trigger --> Field Event Triggers(Select Item Field) --> On Select Add Action as Activate sheet --> Give Sheet ID

[Anonymous]

Hi Vamsi,

Need more details -

1. Do you want to select the 'Car' and open a new tab and at the same time want to hide 'main' tab  according to yur selection ?

ex. if you select 'Audi' then sheet should be visible with Audi details if you select 'BMW' then other Sheet should  be open ? 

BKC