Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SetPasswordEncryptionOptions Method
Collapse the table of content
Expand the table of content

Workbook.SetPasswordEncryptionOptions Method

Sets the options for encrypting the workbook using a password.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

void SetPasswordEncryptionOptions(
	Object PasswordEncryptionProvider,
	Object PasswordEncryptionAlgorithm,
	Object PasswordEncryptionKeyLength,
	Object PasswordEncryptionFileProperties


Type: System.Object
A case sensitive string of the encryption provider.
Type: System.Object
A case sensitive string of the algorithmic short name (i.e. "RC4").
Type: System.Object
The encryption key length, which is a multiple of 8 (40 or greater).
Type: System.Object
true (default) to encrypt file properties.

The PasswordEncryptionProvider, PasswordEncryptionAlgorithm, and PasswordEncryptionKeyLength parameters are not independent of each other. A selected encryption provider limits the set of algorithms and key length that can be chosen.

For the PasswordEncryptionKeyLength parameter there is no inherent limit on the range of the key length. The range is determined by the Cryptographic Service Provider which also determines the cryptographic algorithm.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Community Additions

© 2015 Microsoft