Article ID: 263564 - View products that this article applies to.
This article was previously published under Q263564
This article describes how to remove protection from Excel worksheets and workbooks and how to return a protected, shared workbook to unrestricted use.
If you are not sure whether you need to remove protection from a workbook or a worksheet to gain the access that you want, point to Protection on the Tools menu. If the currently displayed worksheet is protected, the Unprotect Sheet command appears on the Protection menu. If the workbook is protected, the Unprotect Workbook command appears. To determine whether a workbook is shared, look for <Shared> in the title bar.
This information is also covered in more detail in Microsoft Excel 2000 Help. For more information about how to view this information in Help, please see the "References" section later in this article.
To make sure that others do not lose their work in progress, make sure that all other users have saved and closed the shared workbook. On the Tools menu, click Share Workbook, click the Editing tab, and then make sure you are the only user that is listed in the Who has this workbook open now box.
For more information about removing protection, click Microsoft Excel Help on the Help menu, type unprotect in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Article ID: 263564 - Last Review: September 28, 2004 - Revision: 3.1
Contact us for more help