Protect and Unprotect Worksheet

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password.

Protect and unprotect Worksheet in MS Excel

1. Click Review > Protect Worksheet.
2. Enter a password in the Password box.
3. Select allow options.
4. Select OK, re-enter the password to confirm it, and then select OK again.

Protect Worksheet Using Aspose.Cell for .Net

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

//Create a new file.
Workbook workbook = new Workbook();
//Gets the first worksheet.
Worksheet sheet = workbook.Worksheets[0];
//Protect contents of the worksheet.
sheet.Protect(ProtectionType.Contents);
//Protect worksheet with password.
sheet.Protection.Password = "test";
//Save as Excel file.
workbook.Save("Book1.xlsx");

Unprotect Worksheet Using Aspose.Cell for .Net

Unprotecting worksheet is easy with Aspose.Cells API. If worksheet is password-protected, a correct password is required.

//Create a new file.
Workbook workbook = new Workbook("Book1.xlsx");
//Gets the first worksheet.
Worksheet sheet = workbook.Worksheets[0];
//Protect contents of the worksheet.
sheet.Unprotect("password");
//Save Excel file.
workbook.Save("Book1.xlsx");

Advance topics

• Advanced Protection Settings since Excel XP
• Detect if Worksheet is Password Protected
• Protecting Worksheets
• Unprotect a Worksheet
• Verify Password Used to Protect the Worksheet