Protect and Unprotect Workbook Structure

To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.

Protect and Unprotect Workbook Structure in Microsoft Excel

1. Click Review > Protect Workbook.
2. Enter a password in the Password box.
3. Select OK, re‑enter the password to confirm it, and then select OK again.

Protect Workbook Structure Using Aspose.Cells for Java

You only need the following simple lines of code to protect the workbook structure of Excel files.

Unprotect Workbook Structure Using Aspose.Cells for Java

Unprotecting workbook structure is easy with the Aspose.Cells API.

Note: a correct password is required.