Worksheet.Protect(String)

Description

Write-protects the worksheet. A user will not be able to modify the worksheet in Excel without entering the specified password. This method does not encrypt the worksheet.

Parameters

password

The password to use to protect the worksheet. If the password is "" or null, the worksheet will be protected without a password.

Remarks

To further protect your spreadsheet, you can protect the Workbook's structure using the Workbook.Protect() method or password encrypt the file using the Workbook.EncryptPassword property.

Examples