Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Do anyone know why my selection on one sheet is unselected when changing sheet?
I use alternate state for the sheet i use.
When i then go to another sheet and go back again my selections on my alternate state is gone?
How come?
I also use opopen trigger on sheet. But they also dissapear when changing sheet.
Can you share the sample app?
Can you share the sample app?
Go to that sheet properties-->Trigger-->On active sheet--> and on leave sheet--> there is an action clear all
so delete that action from both side
hope it helps you
yes it is in the topic post
i dont have any triggers there
Its only on my alternate sheet this happens. It does not happen on the other sheets. there it keeps its selections
Sorry, by mistake i have deleted the earlier post of mine. No worries, you have got the answer that is more impotant.
Just adding a note:
Thanks for deleting the sample file.
Solution:
Needed to delete ONactivesheet and LeaveSheet on other tabs.
---------
You were right - Sorry! I didnt know the other sheets affected my alternate state.
Thanks for the respone and right answer!