un selections of sheet?

[#1]

Hi i have   five sheets in my application

sheet1

sheet2

sheet3

sheet4

sheet5

my req is if i select sheet1 then selection will reflect sheet 2 and 3...  also

i dont want any reflections in other sheets  ? if i select sheet1 then selections should be there in sheet1 only

2) another one is if i select sheet 1  then refelctions should be there in sheet2 and sheet4  not in sheet3 and sheet5?

is it possible ? if yes? pls let me know?

[alexandros17]

It is possible with alternate states, define them in settings -> document settings-> general tab,

then apply the same state to all the objects of the same sheet

Let me know

[#3]

Suggestion: use alternate states for each tab.

Assign all objects on the same tab to the same alternate state. This way objects on the same tab will respond to each other without influencing objects on other tabs

[#4]

ok good but its a huge work to assigning to all objects right?

i want it for entire sheet only

[morganaaron]

By default objects will have an inherited state - if once you've set each alternate state up you change the state in the sheet properties, objects within that would inherit the state, saving you changing each object.

[jpenuliar]

You can make use of Bookmarks, to apply to your select sheets.

[ashfaq_haseeb · Accepted solution]

You need to look at alternate state.

have a look at attached file that fulfill your requirement.

Regards

ASHFAQ