Deprecated. For spreadsheets created in the newer version of Google Sheets, use the more powerful
Protection
class instead. Although this class is deprecated, it remains available
for compatibility with the older version of Sheets.
Access and modify protected sheets in the older version of Google Sheets.
Deprecated methods
Method | Return type | Brief description |
---|---|---|
| void | Adds a user to the list of users who can edit the sheet, if it is protected. |
| String[] | Returns a list of the email addresses of the users who can edit this sheet. |
| Boolean | Indicates whether the sheet has sheet protection enabled or not. |
| void | Removes a user from the list of users who can edit the sheet. |
| void | Sets the protection status for the sheet. |
Deprecated methods
addUser(email)
addUser(email)
Deprecated. This function is deprecated and should not be used in new scripts.
Adds a user to the list of users who can edit the sheet, if it is protected.
// Add the "[email protected]" user to the list of users who can edit this sheet var sheet = SpreadsheetApp.getActiveSheet(); var permissions = sheet.getSheetProtection(); permissions.addUser('[email protected]'); permissions.setProtected(true); sheet.setSheetProtection(permissions);
Parameters
Name | Type | Description |
---|---|---|
email | String | The email of the user to add. |
See also
getUsers()
getUsers()
Deprecated. This function is deprecated and should not be used in new scripts.
Returns a list of the email addresses of the users who can edit this sheet.
If sheet protection is disabled, the value returned by this call is meaningless.
Return
String[]
— an array of email addresses of users who can edit this sheet
isProtected()
isProtected()
Deprecated. This function is deprecated and should not be used in new scripts.
Indicates whether the sheet has sheet protection enabled or not.
// Determine whether or not sheet protection is enabled var sheet = SpreadsheetApp.getActiveSheet(); var permissions = sheet.getSheetProtection(); var isProtected = permissions.isProtected();
Return
Boolean
— whether the sheet has sheet protection enabled or not
See also
removeUser(user)
removeUser(user)
Deprecated. This function is deprecated and should not be used in new scripts.
Removes a user from the list of users who can edit the sheet.
// Remove the "[email protected]" user to the list of users who can edit this sheet var sheet = SpreadsheetApp.getActiveSheet(); var permissions = sheet.getSheetProtection(); permissions.removeUser('[email protected]'); permissions.setProtected(true); sheet.setSheetProtection(permissions);
Parameters
Name | Type | Description |
---|---|---|
user | String | The email address of the user to remove. |
See also
setProtected(protection)
setProtected(protection)
Deprecated. This function is deprecated and should not be used in new scripts.
Sets the protection status for the sheet.
// Enables sheet protection for this sheet var sheet = SpreadsheetApp.getActiveSheet(); var permissions = sheet.getSheetProtection(); permissions.setProtected(true); sheet.setSheetProtection(permissions);
Parameters
Name | Type | Description |
---|---|---|
protection | Boolean | true to enable sheet protection, false to disable sheet
protection. |