Protect content from changes

In this version of MyOffice Spreadsheet, two types of document content protection set using third-party editors are supported:

•Sheet protection: Users cannot edit all or protected cells of the sheet.

•Document structure protection: Users cannot add, delete, move, rename, duplicate, hide sheets or display hidden sheets.

Unprotect a sheet

If the sheet is protected from editing, the following icon is displayed on the sheet tab: sheet_tabs_protection . To remove the protection, you may need to enter a password.

To remove the protection from the sheet, follow these steps:

1.Click on the sheet tab with the mouse.

2.Open the Manage Protection pane in one of the following ways:

•In the Сommand menu, select Data > Unprotect Sheet.

•Right-click the sheet tab and execute the context menu command Unprotect Sheet.

•On the Sidebar, click side_panel_protection .

3.In the Sheet tab:

•If the sheet is password protected, enter the password and click Unprotect Sheet.

•If the sheet is not password protected, click Unprotect Sheet.

4.To close the Manage Protection pane, do one of the following:

•At the top of the pane, click side_panel_search_close .

•On the Sidebar, click side_panel_protection .

Unprotect sheet structure

To remove the protection, you may need to enter a password.

To unprotect the sheet structure, follow these steps:

1.Open the Manage Protection pane in one of the following ways:

•In the Сommand menu, select Data > Unprotect Spreadsheet Structure.

•On the Sidebar, click side_panel_protection .

2.On the Spreadsheet Structure tab:

•If the document structure is password protected, enter the password and click Unprotect Sheet.

•If the document structure is not password protected, click Unprotect Sheet.

3.To close the Manage Protection pane, do one of the following:

•At the top of the pane, click side_panel_search_close .

•On the Sidebar, click side_panel_protection .

Was the material useful?

Yes