2. User goes to sheet 'Planning', where we don't use filter 'Year'. The current selection box has to show all selections, excepts filter 'Year'.
3. When the user leaves sheet 'Planning' the selected\saved years of point 1 has to be working again.
Below one of the many options I tried to solve this. I don't know how to solve point 3 of the process.
Please let me know if there is a better solution to achieve above process.
I manage to make OnActivateSheet triggers in sheet 'Planning' to set the variable of year selections (see blue text box) and clear field 'Year' (see list box Year) for the desired presentation of the current selection box of point 2. But how do I realize point 3 with the OnLeaveSheet trigger? Is it possible to activate the year selections variable (vYearSelected) again, so the user can work further with the selections of sheet 'Dashboard' made in point 1?