HOW TO ACTIVATE NEXT SHEET ?

[#1]

I have a PRODUCT_TYPE, table, which has, for example, CHOCOLATE & STRAWBERRY. how do i modify it such that, when i click STRAWBERRY, it automatically changes to the next sheet ? must i use triggers?

[#2 · Accepted solution]

hi Nileshrocks yes, we can get ur requirement in two ways. one is by using triggers and another by macros. but macros kills efficiency of our application. i have a solution for ur`s.

Goto

Settings-> Document Properties -> Triggers -> Field Event Triggers ->

select the STRAWBERRY field and click "on select Edit Actions.." button

click on ADD button and select Action Type as "LayOut" and select Action as "Activate Sheet" and then click on "OK" button.

Now write the below condicion in the "Sheet ID" Text Box

=if(getSelectedCount(STRAWBERRY ) >0,SH02,)

i think it will work, otherwise use the below one..

SH02

Regards

A'run'