How to unprotect a sheet in Excel 2010

We have already discussed about protecting a workbook structure and preventing users from adding new Worksheet. In this tutorial we will find out to unprotect a Workbook.

When you navigate to the Info menu of a protected Workbook, it will display that the structure of the workbook is locked.

image

You can remove this protection by clicking the down arrow available below the Protect Workbook icon and selecting Protect Workbook Structure from the displayed menu list.

image

Now enter the password to Unprotect the Workbook and click OK button.

image

This would remove the protection on the Workbook and now you will be able to add, delete or move the sheets.

In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.