Skip to main content

Protect Sheet Dialog

The Protect Sheet dialog allows end-users to protect worksheet elements using an optional password. Worksheet protection locks cells and allows you to only perform specific actions.


Add the Changes group to enable the Protect Sheet button, which invokes the target dialog. Refer to the Create a Simple Spreadsheet Application topic for details on how to provide a Ribbon UI for the SpreadsheetControl.


In a protected sheet, this button displays the “Unprotect Sheet“ caption, which invokes a simple dialog that prompts for a password or unlocks the sheet if no password was set.


All worksheet cells are locked by default. When protection is applied to the worksheet, these cells become read-only. However, end-users can allow performing certain actions in a protected worksheet by checking corresponding boxes in the Allow all users of this worksheet to list.


The Select locked cells and Select unlocked cells options (the WorksheetProtectionPermissions.SelectLockedCells and the WorksheetProtectionPermissions.SelectUnlockedCells parameters) do not affect the SpreadsheetControl behavior. The cells are always selectable.

See Also