For a workbook composed of multiple spreadsheets, select Protect Workbook followed by Unprotect Workbook. Enter the Workbook password again when prompted and select OK to remove protections.

This also allows the workbook merging check box. For some reason, if you find the checkbox is not visible, unprotect the workbook. Now, to remove shared workbook protection, do the following: ...

How to Tell If a Worksheet Is Protected in Microsoft Excel 2003. Protecting a worksheet in Excel 2003 prevents others users from editing it. For example, if you have tracked and charted your ...

Using Microsoft Excel 2007, you can protect worksheets in order to keep other users from making changes. Unfortunately, this protection applies to everything on the worksheet, including groups.