restrict access to sheet in the script

[#1]

Hi,

In the attached app I have set up I want to build some security into it.

I have resricted access to the tab in question (cost) using a conditional show sheet on the sheet properties. Next and final step is restricting access to a tab in the script called 'cost'. I don't want peple in my team to see the detail in here.

Can someone please help in telling me how I can do this? Really not good with section access so apologies if this is really simple.

Chris

[avinashelite]

Please check this threads:

Sheet level access

Section access on sheet level‌

[Anonymous]

FOr security at front end use

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, GROUP

    ADMIN, ADMIN, PASSWORD, *

    USER, ABC, PASSWORD, 1

    USER, XYZ, PASSWORD, 2

];

Section Application;

LOAD * Inline [

GROUP, SHEET1,SHEET2,SHEET3

1,1,0,1

2,0,1,1

];

and at properties of sheets use conditional show

example> at sheet 1  use if(sum(SHEET1)>0,1,0) and so on.

For scritp level security as you dont want others to check for Cost tab, then you can create hidden script and place it there.

[#4]

How do you create a hidden script?

Chris

[avinashelite]

Go to edit script>file>hidden script

[#6]

Its greyed out...can't select it

[SreeniJD · Accepted solution]

Hi Chris,

It will be available in Edit Script-> File  menu-> Create Hidden Script, It will open a popup window for requesting New Password and Confirm Password (to later unhide the script).

Create a new QVW and then see whether "Create Hidden Script" is still greyed out?

Sreeni

[avinashelite]

You must login as the ADMIN to access it