Current selection restriction

[qdivyact]

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

[nagarjuna_kotha]

you can by pass the selections in particular field using set analysis

-Nagarjun

[nagarjuna_kotha]

can you explain clearly, you want  hide particular object in particular sheet or you want restrict the selections in particular field and sheet?

-Nagarjun

[qdivyact]

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.

[nagarjuna_kotha · Accepted solution]

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

[buzzy996]

Just do the same on both the sheets

[avinashelite]

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

[qdivyact]

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 !

[avinashelite]

ok please mark the correct and helpful answers and close this thread