Excel.Interfaces.AllowEditRangeLoadOptions interface
Represents an AllowEditRange
object found in a worksheet. This object works with worksheet protection properties. When worksheet protection is enabled, an AllowEditRange
object can be used to allow editing of a specific range, while maintaining protection on the rest of the worksheet.
Remarks
[ API set: ExcelApiOnline 1.1 ]
Properties
$all | Specifying |
address | Specifies the range associated with the object. Worksheet protection must be disabled or paused for this method to work properly. If worksheet protection is enabled and not paused, this method throws an |
is |
Specifies if the object is password protected. |
title | Specifies the title of the object. Worksheet protection must be disabled or paused for this method to work properly. If worksheet protection is enabled and not paused, this method throws an |
Property Details
$all
Specifying $all
for the load options loads all the scalar properties (such as Range.address
) but not the navigational properties (such as Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
address
Specifies the range associated with the object. Worksheet protection must be disabled or paused for this method to work properly. If worksheet protection is enabled and not paused, this method throws an AccessDenied
error and fails to set the range.
address?: boolean;
Property Value
boolean
Remarks
isPasswordProtected
Specifies if the object is password protected.
isPasswordProtected?: boolean;
Property Value
boolean
Remarks
title
Specifies the title of the object. Worksheet protection must be disabled or paused for this method to work properly. If worksheet protection is enabled and not paused, this method throws an AccessDenied
error and fails to set the title. If there is already an existing AllowEditRange
with the same string, or if the string is null
or empty (""), then this method throws an InvalidArgument
error and fails to set the title.
title?: boolean;
Property Value
boolean
Remarks
Office Add-ins