Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have created a small application for internal purpose and I want to share the file with many users. I want to hide one sheet and protect edit script option in the application. But it should be visible only when I open in my system. I have read many threads in the forum but I could not find how to implement the section access. It can be shared with many users, so I can't get each users ID. My requirement is just want to protect a sheet and edit script option to all users except me.
Please guide me.
Thank you.
In the script editor (using FILE menue on top) create a hidden script as very first tab, insert Section Access (by INSERT > Section Access Inline in top menue and set yourself as ADMIN and others as a USER with a general name like
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, JOHN.SNOW, WINTER
USER, USER, TESTPASSWORD
];
Section Application;
On the dashboard > Document Properties > Security change settings for
-Edit script
-Reload
-Access Document Properties
-Allow User reload
...
And do a copy for safety reasons...if something goes wrong, you might not have access to your own app anymore
Thanks for the reply Daniel. Unfortunately, My application is locked when I ran the below code, but I have a copy . What I have tried is just mentioning the windows login ID in the USER ID field. See below.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, AS-VW/TAMIL.NAGARAJ, WINTER
USER, USER, TESTPASSWORD
];
Section Application;
I just want to protect the application with windows login id. Can you correct me.
Please have a look at the document attached as I am not fully aware about implications of Windows ID access.
Hope it helps
Cheers
Daniel