Sheet Trigger

[#1]

Hi, Experts .

Suppose i have 10 Sheets In my Dashboard. while i executing that last 3 sheets not to execute,i want to execute only first 7 sheets.

Is there method to do this please help me.

[#2]

if u want Restrict Selection in last 3 Sheet then

go to sheet properties select trigger on sheet activation  then clear all Selection

in this 3 sheet u have to do same things

by this way u  can achieve desired result

hope this helps

[agilos_mla]

Alternate states is the best solution in your case. It's flexible since it allows eithet to disregard all selections in the other others or to combine some selections with specific in the 3 sheets.

I advise you also to use button to copy/transfer states (import/export selections between sheets)

HTH,

Michael

[marchoctober]

Thanks!

Yes, Alternate states is very flexible solution.

[#5]

Thank You ALL TO HELP ME.