Reference>IXLSWorksheet>Protect

Protects a worksheet so that it cannot be modified.

Syntax

procedure Protect();

procedure Protect(Password: string);

Password

String. A string that specifies a case-sensitive password for the worksheet. If this argument is omitted, you can unprotect the worksheet without using a password. Otherwise, you must specify the password to unprotect the worksheet.

Example

This example protects worksheet one.

Workbook.Sheets[1].Protect('mypass123');

NativeExcel suite v2.x

Protect method

Syntax

Example