ExcelScript.AllowEditRangeOptions interface
The interface used to construct optional fields of the AllowEditRange
object.
Remarks
Examples
/**
* This script adds a password-protected, editable range
* to an otherwise protected worksheet.
*/
function main(workbook: ExcelScript.Workbook, password: string) {
// Get the protection object for the "Data" worksheet.
const dataSheet = workbook.getWorksheet("Data");
const sheetProtection = dataSheet.getProtection();
// Set the password needed to edit the range to be the user provided string.
const editRangeProperties : ExcelScript.AllowEditRangeOptions = {
password: password
};
// Set range "D2:D6" to be editable if the password is provided.
sheetProtection.addAllowEditRange("Notes Section", "D2:D6", editRangeProperties);
// Protect the worksheet.
sheetProtection.protect();
}
Properties
password | The password associated with the |
Property Details
password
The password associated with the AllowEditRange
.
password?: string;
Property Value
string