You can protect the structure of your Excel workbooks from being altered by applying Workbook Protection. For example, you can prevent users from adding, hiding, deleting, renaming, unhiding, moving or copying worksheets. Additionally, you can set an option that locks the window size and location of a worksheet so that it cannot be altered by users.
To Protect a Workbook
1. Click the Review tab on the Ribbon.
2. Click the Protect Workbook button on the Changes group.
3. Select Structure to prevent the physical modification of the workbook.
4. Select Window to prevent changes to the size and position of the workbook window.
5. Enter a password in the Password text box.
6. Click OK.
7. Reenter password in the confirm password box.
8. Click OK
Tip: There is another way to password protect the structure workbook, which allows you to specify a password necessary to modify the workbook. Click the File tab > Info, click the Protect Workbook icon in the center pane and then click Protect Workbook Structure. Enter the password necessary to modify the file.
Share this post