Remove protection from a spreadsheet

Office Web Components

Remove protection from a spreadsheet

This procedure can be performed at design time only. Browser users do not have access to this option.

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. On the toolbar, click Commands and Options Button image, and then click the Protection tab.
  3. Under Sheet, clear the Protect active sheet check box.
  4. If you want users to be able to insert, remove, or rename sheets, or use the Commands and Options dialog box, check to be sure that the Insert, remove, or rename sheets check box and the Commands and Options dialog box check box under Workbook are selected.