Create a bookmark to store the selection. Then add a Replace Bookmark action to the OnLeaveSheet trigger of tab1. Use the bookmark you just create for the Bookmark setting of the action. Next add a Clear All action. Then add a Apply Bookmark action to the OnActivateSheet trigger of tab1. Use the same bookmark for the Bookmark setting of the action.
But I have more than 2 tabs in my dashboard, Just for the sake of simplicity I explained with only 2 tabs. Say I have 6 tabs, the date field must be cleared on activation of only tab4. When I move back from tab4 to any other tabs the selections must be set back.
How do I do this... any idea?