Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks!
Yes, Alternate states is very flexible solution.
Thank You ALL TO HELP ME.