Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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.

Signature
C#
C#
 public void Protect(System.String password)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Sub Protect(ByVal password As String)
{signature}
{parameters}
{param:password}The password to use to protect the worksheet. If the password is "" or null, the worksheet will be protected without a password.{param}
{remarks}
To further protect your spreadsheet, you can protect the Workbook's structure using the [Workbook.Protect()|Workbook.Protect(String)] method or password encrypt the file using the [Workbook.EncryptPassword] property.
{remarks}
{example}{code:csharp|title=C#}
Parameters
Param
password
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.

Example
Code Block
csharp
csharp
titleC#

ws.Protect("MyPassword");
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

ws.Protect("MyPassword")
{code} {example}