Sheet Properties

[mario-sarkis]

hey all

My question is that i have many sheets  tab in the same dashboard my request is

when i select a field on the first sheet i need to clear it's selection when i move to other sheets and VICE VERSA But when i select on a field in the other sheets it will remove its selection only when i move to the first sheet .

Hope that you can help .

Thank you,

[#2]

Hi Mario,

sounds like you just want to clear the selection when going to or leaving that first sheet? If so you can see a trigger on the specific sheet to do that on activate and leave.

Hope that helps

Joe

[Anonymous]

You need to add action "clear all" to both "enter sheet" and "leave sheet" triggers - only on the first sheet.

[Anonymous]

Apply sheet triggers in all sheets as on activate sheet: clear all Trigger

[Anonymous]

Hi,

On each sheet   select, Sheet Properties--->Triggers---> Sheet Event Triggers ---> On Active Sheet---> Edit Actions

Add Action--->Selection-->Clear All

this form every time  you  to open  one  sheet will clear  selections previous

Regards!!

Jannet.