Independent selections in different sheets

[arixooo123]

Is it possible to have independent Selections in different sheets?  if no, i read in one of posts in here that the only thing we can do is to set selection boxes automatically clear the selections after changing sheets.  i don't know how to do that either..if you know i would be grateful to tell me.

thank you

[eduardo_sommer]

It is possible. You can define alternate states for each sheet, so that the selections in one sheet doesn't interfere with the selections in the other. Take a look in this post: ALTERNATE STATES

Eduardo

[fkeuroglian · Accepted solution]

Hi, you could that clear all the selections  when you acces to the sheet or when you leave the sheet

go to:

1) Right click in the sheet, property of sheet

2) go to trigger

3) go to Add a action(choose when you leave the page or acces to the page)

4)go to add

5)selection

6)delete all

this mean that when you acces or leave the page will delete all the selections

good luck

Fernando

[#4]

Hi,

Another possible option is to create bookmarks for each sheet.

Then you set the below triggers in the sheet properties under the Triggers tab:

OnActivateSheet: Add > Bookmark > ApplyBookmark action and type the bookmark ID that you want to be related to that sheet.

OnLeaveSheet: Add > Bookmark > ReplaceBookmark action and type the same bookmark ID.

In this way you'll have independent selections with the possibility to save and load back the selections within every sheet.