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.

[MK_QSL]

Go to sheet properties and under Show Sheet Conditional write 1 = 2

[#3]

what do u mean by "executing" Exactly

[Anonymous]

Go to sheet properties and under Show Sheet select Conditional and write condition so sheets are disabled.

or use section access for sheet security Sheets Security with Section Access, if you want certain users should have access to sheets or not.

[maxgro]

if you're referring to user interface sheets (hide sheets) as Manish already said

in Sheet Properties --> General tab --> Show Conditional --> 0

if you're referring to script (execute tab script) you can use

exit script;

at any point in your script to not execute the following script tabs

[sundarakumar]

use

exit script;

at the end of seventh sheet  (i guess u r talking about script editor tabs).

-Sundar

[aveeeeeee7en]

Hi Shan

As Sundarakumar said i also think that you are talking about Script Tabs.

Kindly see the Attached Images.

Hope this will help you.

Regards

Aviral Nag

[#8]

Hi, Executing means that when i do any selection in sheet1/2/3... It automatically reflect all the sheets and selection will happen. But i want to restrict the selection in the Last 3 sheets.

[simsondevadoss]

Hi Shan,

In last 3 sheets, Go to sheet properties-> triggers->on activate sheet(add actions)-> clear all.

So that your selection will not get reflected in those sheets.

Hope this helps.

Thanks,

Simson

[marchoctober · Accepted solution]

You could also use possible solutions depends on your task, f.e. we are using alternate states.

If you have no state go to Document Settings General > Alternate states button, and add some state.

Further sheet properties at the top choose that state.

Further everything you do in this state will reflect only those objects and sheets that are in same state, esle it will reflect to default states.

I repeat, depending on your task there are a lot of variants and options to perform.