Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to restrict current selection to particular sheet. do we have any option to implement this other than Alternate state.
Am not using current selection box its a text object with GetCurrentSelections().
Thanks,
Divya
how you are going to sheet 1 and sheet 2 , are you using action type action or directly selecting ur sheets?
If you are using active sheet action , then add one more action clear all action
or else
Direct add for both seets
Properties>>triggers>>OnActiveSheet>Add clearll action in the both the sheets
-Nagarjuna
you can by pass the selections in particular field using set analysis
-Nagarjun
can you explain clearly, you want hide particular object in particular sheet or you want restrict the selections in particular field and sheet?
-Nagarjun
I have two sheets SH01 & SH02 and GetCurrentSelections() text object in both sheets. Now the selections made in SH01 should not be displayed in SH02 GetCurrentSelections() and vice versa.
how you are going to sheet 1 and sheet 2 , are you using action type action or directly selecting ur sheets?
If you are using active sheet action , then add one more action clear all action
or else
Direct add for both seets
Properties>>triggers>>OnActiveSheet>Add clearll action in the both the sheets
-Nagarjuna
Just do the same on both the sheets
Any reason you don't want to go with the Alternate state ? because it could be easily achieved using applying the Alternate state on the whole sheet so that it won't effect the other.
Otherwise you need to go with the Sheet Triggers and clear the selection but when you go back to sheet 1 you won't get the selection made !! but if you use the Alternate state you would retain the selection in the sheet 1 also
Hope this helps you
Hi all Thanks for your response !
I am going with Alternate state itself as i have to retain the selections on switching to other sheet. More over the requirement is to segregate one set of sheets from other, Say SH01 to SH10 should have one set of selections and current selection should be visible in all the 10 sheets & SH11 to SH20 should have other set of selections current selection should be visible in the other 10 sheets.
Thanks again !
ok please mark the correct and helpful answers and close this thread