Protect and Unprotect Workbook Structure

Protect and unprotect Workbook Structure in MS Excel

protect and unprotect workbook structure

  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.Cell for Java

Only need the following simple lines of code to implement protecting workbook structure of Excel files.

//Create a new file.
Workbook workbook = new Workbook();
//Protect workbook structure.
workbook.protect(ProtectionType.STRUCTURE, "password");
//Save Excel file.
workbook.save("Book1.xlsx");

Unprotect Workbook Structure Using Aspose.Cell for Java

Unprotecting workbook structure is easy with Aspose.Cells API.

//Open an Excel file which workbook structure is protected.
Workbook workbook = new Workbook("Book1.xlsx");
//Unprotect workbook structure.
workbook.unprotect("password");
//Save Excel file.
workbook.save("Book1.xlsx");