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.
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.
Go to sheet properties and under Show Sheet Conditional write 1 = 2
what do u mean by "executing" Exactly
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.
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
use
exit script;
at the end of seventh sheet (i guess u r talking about script editor tabs).
-Sundar
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
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.
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
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.