So, what exactly is workbook-level protection?
In the previous section on how to password protect your workbook, we mentioned workbook structure. This refers to the composition of the worksheets within the Excel file.
This type of protection restricts the “rules” of other users. Other users won’t be able to add, delete, move, or change the names of any of the existing worksheets within your workbook file.
They can view and even change contents within the worksheets. But, they cannot change anything at the worksheet (or workbook structure) level.