Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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