Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Excel.Interfaces.WorksheetProtectionLoadOptions interface
- Package:
- excel
Represents the protection of a worksheet object.
Properties
| $all | Specifying |
| canPauseProtection | Specifies if protection can be paused for this worksheet. |
| isPasswordProtected | Specifies if the sheet is password protected. |
| isPaused | Specifies if worksheet protection is paused. |
| options | Specifies the protection options for the worksheet. |
| protected | Specifies if the worksheet is protected. |
| savedOptions | Specifies the protection options saved in the worksheet. This will return the same |
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
canPauseProtection
Specifies if protection can be paused for this worksheet.
canPauseProtection?: boolean;
Property Value
boolean
Remarks
isPasswordProtected
Specifies if the sheet is password protected.
isPasswordProtected?: boolean;
Property Value
boolean
Remarks
isPaused
Specifies if worksheet protection is paused.
isPaused?: boolean;
Property Value
boolean
Remarks
options
Specifies the protection options for the worksheet.
options?: boolean;
Property Value
boolean
Remarks
protected
Specifies if the worksheet is protected.
protected?: boolean;
Property Value
boolean
Remarks
savedOptions
Specifies the protection options saved in the worksheet. This will return the same WorksheetProtectionOptions object regardless of the worksheet protection state.
savedOptions?: boolean;
Property Value
boolean
Remarks
Office Add-ins
Feedback
Was this page helpful?
