ProtectWorkbookPassword Property (Workbook)

Sets/gets the password for protecting the elements in workbook.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ProtectWorkbookPassword As System.String

public System.string ProtectWorkbookPassword {get; set;}

Remarks

The password will take effect when one of ProtectWorkbookWindows and ProtectWorkBookStructure property is true. If one or both ProtectWorkbookWindows and ProtectWorkBookStructure property are set to true, Workbook.Save method will be invoked.At this time, ProtectWorkbookPassword validity will be checked.
If file format is Xls95/Xls97Plus, InvalidPasswordExpection will be thrown out if ProtectWorkbookPassword contains more than 15 characters.If file format is Xlsx, InvalidPasswordExpection will be thrown out if ProtectWorkbookPassword contains more than 255 characters.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Workbook Class
Workbook Members