Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement is like in my report i have some sheets from those am dispplaying some sheets with conditional display and i have 2 sheets (Intro,Howto) for these 2 sheets dnot require conditional display. From this file whenever if i click sheet1,sheet2.....etc respective sheet sholud disaply but if i click any of the sheet from list box its taking me to directly intro sheet. How to fix this......i have attached sample file here
It's not moving, your Sheet1 is activated and visibile on the position that you created it. If you want it to be displayed after the how-to tab, you need to move / promote your sheet once with the appropriate menu command. See attached.
You could use a trigger on changes on field A with an layout action of type acitvate sheet. See attached.
HI swuehl thnx for replay its perfectly working for sheet2,sheet3 but for sheet1 its again moving just have look it and
where do i change/apply triggers and any more changes in sheet.
It's not moving, your Sheet1 is activated and visibile on the position that you created it. If you want it to be displayed after the how-to tab, you need to move / promote your sheet once with the appropriate menu command. See attached.
yes yes...now its working perfectly......thnx swuehl but where i have to apply this triggers and all could you please explain it beacuse am not getting how to do this....
Go to Settings - document properties - triggers.
There are two actions (identically) set on Field Event Triggers for field A (OnSelect / OnChange).
Note that I renamed the sheet IDs of those sheets to be identically with your Field A values, so I can just use =A as expression for the activate sheet action (See sheet properties - general tab).
Thanx very much swuehl now every thing is perfect....
swuehl one problem here in my live application it is not working i have tried this agian with a test file there its working.....
Hm, hard to tell from the distance. Have you checked that the sheet IDs are correctly referenced?
Yes i got the problem here actually it is working for
But am having a tree structure like
=='Sheet1/Sheet12/Sheet123' ...etc
Sheet12,Sheet123 are nested sheets under Sheet1 for these nested sheets it is not working . How to do for nested sheets.....