Sheet Properties - Triggers

[priyarane]

Hi Experts,

I want clear all the in current selections, if I go for further sheets. But my selections should be there if I come back to my sheet.

ex:

Sheet1 - Current selections - Dim:A

Once I leave from Sheet 1 then it should not be there on Sheet 2. if again, come back to sheet 1 current selections should be the same

Sheet2

[alex_millan]

Hi Priya,

Why not to configure Sheet2 in a different state than Sheet1? Would that suit to your requirements?

That would allow you to make a different selections in Sheet2 that wouldn't affect to Sheet1 using 'Alternate States'

Regards

[Gysbert_Wassenaar]

Use bookmarks. Create a bookmark first. When you want to leave the sheet use a Replace Bookmark as the first action and an Activate Sheet action as the second and finally a Clear All action. When you want to return to the sheet you can use the Activate Bookmark action and then the Activate Sheet again.

[sorrakis01]

Yes,

Create a bookmark.

[priyarane]

Hi Gysbert,

In my case, I have 4 sheets and created 4 buttons on all the sheets and added the actions on 4 buttons as active sheet.