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.
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.
Now enter the password to Unprotect the Workbook and click OK button.
This would remove the protection on the Workbook and now you will be able to add, delete or move the sheets.