Sheet Level Section Access is not working

[#1]

Hi Folks,

Sheet level Section access is not working,

1. EditScript > i created the script like below snippet.

2. Before applied the code i enable the "Initial Data reduction on section access" and "Strict Exclusion".

3. reload the data and closed it.

4. now i try to open with user login, but here it was showing 4 sheets.

i don't know where i did the mistake

can some one help me with this..

Thanks in advance..

@Sub2u444

[Gysbert_Wassenaar]

Creating a table with sheetid's will not automatically arrange sheet level access control. You need to use the Conditional display condition of the sheet to show/hide the sheet based on the access table. See for example this document: Sheets Security with Section Access. Or this one: Section Access - Hide Sheet Level