Sheet Protection: Data entry forms, web application

Sheet protection does not mean that cell contents is protected. To protect cell contents from editing, select the Locked checkbox on the Advanced tab in the Other group of parameters on the parameters panel.

Setting Sheet Protection

To protect the sheet, select the Protect Sheet item in the context menu of the selected sheet's tab.

In the dialog box that opens set password to remove sheet protection in the Password to Remove Sheet Protection box. There are no restrictions on password length and used characters.

Select the operations that can be executed with the sheet. Select a checkbox to enable the operation. All checkboxes are selected by default. Deselect a checkbox to prohibit an action.

After the checkbox is deselected, cell formatting settings in the Format Cells group of parameters and on the Formatting toolbar tab become unavailable.

After the checkbox is deselected, settings for changing row height, hiding rows, and displaying hidden rows become unavailable.

After the checkbox is deselected, settings for changing column width, hiding columns, displaying hidden columns become unavailable.

When the checkbox is deselected, selection and working with objects will be unavailable.

After the checkbox is deselected, one cannot add columns, and the Insert > Move Cells Right item in the column/cell's context menu becomes unavailable.

After the checkbox is deselected, one cannot add rows, and the Insert > Move Cells Down item in the row/cell's context menu becomes unavailable.

When the checkbox is deselected, new and copied objects cannot be inserted.

When the checkbox is selected, use the ITabObjects.Add method to insert new objects or copy existing objects.

After the checkbox is deselected, one cannot delete columns, and the Delete > Move Cells Left item in the column/cell's context menu becomes unavailable.

After the checkbox is deselected, one cannot delete rows, and the Delete > Move Cells Up item in the row/cell's context menu becomes unavailable.

When the checkbox is deselected, object deletion will be unavailable.

After the checkbox is deselected, filtering becomes unavailable.

When the checkbox is deselected, rotation, placing object within the specified cell range and setting up size and position will be unavailable.

Click the Apply button to apply changes. If password was not set, the sheet will be protected by default.

Removing Sheet Protection

To remove protection, select the Remove Sheet Protection item in the context menu of the selected sheet's tab. If the password was not set, sheet protection is removed at once. If the password was set, the Remove Sheet Protection dialog box opens:

Enter the password and click the Confirm button. If the password was correct, sheet protection is removed, and the user can execute all operations with the sheet.

If the password was incorrect, an error message is displayed, and sheet protection remains active.