These methods manage the list of users who can edit a protected sheet and set the protection status.
PageProtection
Deprecated.For spreadsheets created in the newer version of Google Sheets, use the more powerfulProtectionclass 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.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 "user@example.com" user to the list of users who can edit this sheetconstsheet=SpreadsheetApp.getActiveSheet();constpermissions=sheet.getSheetProtection();permissions.addUser('user@example.com');permissions.setProtected(true);sheet.setSheetProtection(permissions);
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()
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 enabledconstsheet=SpreadsheetApp.getActiveSheet();constpermissions=sheet.getSheetProtection();constisProtected=permissions.isProtected();
Return
Boolean— Whether the sheet has sheet protection enabled or not.
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 "user@example.com" user to the list of users who can edit this// sheetconstsheet=SpreadsheetApp.getActiveSheet();constpermissions=sheet.getSheetProtection();permissions.removeUser('user@example.com');permissions.setProtected(true);sheet.setSheetProtection(permissions);
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 sheetconstsheet=SpreadsheetApp.getActiveSheet();constpermissions=sheet.getSheetProtection();permissions.setProtected(true);sheet.setSheetProtection(permissions);
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-12 UTC."],[],[]]
