Leaving a Sheet Event

[manpri7078]

Hi all,

I have a one very basic query. Suppose Sheet 2 is activated. When I activate Sheet 1, Sheet 2 should be hidden. On Sheet 2's properties what conditional expression should I write for Show, to achieve this. This should be very simple, but I am simply not able to do that.

Regards,

Manish Prasad

[kaushiknsolanki]

Hi,

    Do one thing, Create a Variable say vShoqHide

    Give default value as 1.

    Now create a button on both the sheets,

    on sheet1's Button, add action to set the variable value to 2.

    and go to sheet properties -> General -> Show Sheet -> Conditional

    Add expression as =if(vShowHide = 1,1,0)

    Now on sheet2's Button, add action to set the variable value to 1.

    and go to sheet properties -> General -> Show Sheet -> Conditional

    Add expression as =if(vShowHide = 2,1,0)

    For more clarification have a look at the attached example

Regards,

Kaushik Solanki

[nivethitha]

Hi,

There is also an another way,

create an inline table in edit script

Load * inline [

No, SheetID

1,SH01

2,SH02

];

No is just to denote, and Sheetid is the respective id of sheet1 and sheet2.

now create a list box in both in sheets with the field 'No'

In Sheet1, give the condition as No=1

In sheet2, give the condition as No=2

U will get the expected result when the value 1 or 2 is clicked from the list box.

Regards,

Nivethitha

[manpri7078]

Hi,

I agree with what you are saying or what Kaushik was also suggesting. I am clarifying my query a little bit more. In my document I have one sheet (SH01). In that sheet there is one clickable object which activates another sheet, say SH02 for in depth analysis. Now I wants that when I leaves that sheet (SH02) and returns to SH01, that sheet (SH02) gets hidden, until I again click on the clickable object in SH01, which should be permanently shown. Sheet SH02 will be displayed only when required if I click the clickable object on Sheet SH01 and not otherwise.

I hope I am able to put my query more clear now. Is this possible and if yes, how ?

Regards,

Manish Prasad

[#5 · Accepted solution]

HI manish,

check the attached one.

Regards

Kumar

[manpri7078]

Dear Ravi,

Thanks a lot for your reply. It solved my problem and now I have been able to accomplish what I wants.

Regards,

Manish Prasad

[rajni_batra]

Hi manish,

If ur issue has been resolved then plz mark Ravi's answer  as correct answer and close the thread.

Regards,

Rajni

[#8]

nice nivi