IssueTracker

Would like to be able to protect sheet then unprotect certain cells or ranges within the protected sheet so that it may facilitate users with input(create a form in essence).

The UI Services will probably make this redundant. I will definitely go Pro as soon as I get a credit card.

I discover an something into core "trix" in javascript. I see a function and a object as "getSpreadSheetConfig" and "setSheetProtection". I believe that this function/object can edit the Sheet Protection in a work book. You can investigate and try to find any solution for this issue.

I'm sorry my bad english

Please Google Apps Team Help us quickly !!!

This is a really big hole in an otherwise tasty donut.

Further to be able to set/get a given sheet read/write access, I suggest, for future development :

- to add the "no access at all" access level (I mean that the user that has this access cannot at all open this given tab sheet, but might be able to read or write on another sheet)

- to add access control by user on cells

There is now a Sheet#setSheetProtection method available.

Here is a sample to demonstrate it's usage:
// Add the "user@example.com" user to the list of users who can edit this sheet
var sheet = SpreadsheetApp.getActiveSheet();
var permissions = sheet.getSheetProtection();
permissions.addUser('user@example.com');
permissions.setProtected(true);
sheet.setSheetProtection(permissions);

The full documentation will be out very soon.

Best,
Anton

See the release notes for pointers to the documentation: https://developers.google.com/apps-script/release_notes