How to protect workbook structure in Excel 2016 ?

If you don’t want the users to perform actions on workbook , one of the best option is to protect the structure of the workbook.

How to protect workbook structure in Excel 2016 ?

When you protect the structure of the workbook , you are restricting the users from inserting , renaming or deleting the worksheets.To protect the workbook structure , follow the below steps.

1. Open the excel workbook and select "Review" Ribbon menu and click "protect Workbook" from the changes group.
image

2. In the Protect Structure and Windows dialog , select the structure checkbox. If needed , provide the password and click OK button.

image

Once you do this , you will no longer be able to perform actions like insert , delete , rename or move sheets in the workbook.

No Responses

Leave a Reply