Version

Search Results

WorksheetProtectedSelectionMode Enumeration

Enumeration used to indicate which cells may be selected when the Worksheet is protected. Syntax Members Member Description AllCells All cells including locked cells may be selected. NoCells The selection cannot be change. UnlockedCells Only cells that are unlocked may be selected via the keyboard or mouse. Note a...

WorksheetProtection Class

Provides information about the types of changes that are disabled when the associated Worksheet is protected. Syntax Remarks When a Worksheet is protected, the contents of unprotected cells may be edited by the end-user. One way to unprotect a cell is to change the IWorksheetCellFormat.Locked property to false. Su...

WorksheetProtection Class Events

For a list of all members of this type, see WorksheetProtection members. Public Events Name Description PropertyChanged Occurs after a property value has changed Top

WorksheetProtection Class Members

Public Properties Public Events

AllowDeletingColumns Property

Returns a boolean indicating if the deletion of columns is allowed in a protected worksheet. Syntax

AllowDeletingRows Property

Returns a boolean indicating if the deletion of rows is allowed in a protected worksheet. Syntax

AllowedEditRanges Property

Returns a collection of WorksheetProtectedRange instances that define which locked ranges of cells may be edited in a protected worksheet. Syntax Remarks When a Worksheet is protected the only cells that may be edited are those whose IWorksheetCellFormat.Locked property has been set to false. All other cells are n...

AllowEditObjects Property

Returns a boolean indicating if objects such as shapes, comments, charts and controls may be created or changed when the worksheet is protected. Syntax