SetAnyoneType
Sets the type of the "Anyone" user to the current protected range.
Syntax
expression.SetAnyoneType(protectedRangeUserType);
expression - A variable that represents a ApiProtectedRange class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| protectedRangeUserType | Required | ProtectedRangeUserType | The user type of the protected range. |
Returns
boolean
Example
Set the default access level that applies to all users of a protected range in a spreadsheet.
// How do I control what anyone without explicit permission can do with a locked range in a spreadsheet?
// Restrict or open a protected range to everyone by choosing a blanket access level in a spreadsheet.
let worksheet = Api.GetActiveSheet();
worksheet.AddProtectedRange("protectedRange", "Sheet1!$A$1:$B$1");
let protectedRange = worksheet.GetProtectedRange("protectedRange");
protectedRange.SetAnyoneType("CanView");