_Workbook.SetPasswordEncryptionOptions(Object, Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Sets the options for encrypting workbooks using passwords.

public void SetPasswordEncryptionOptions (object PasswordEncryptionProvider, object PasswordEncryptionAlgorithm, object PasswordEncryptionKeyLength, object PasswordEncryptionFileProperties);

Public Sub SetPasswordEncryptionOptions (Optional PasswordEncryptionProvider As Object, Optional PasswordEncryptionAlgorithm As Object, Optional PasswordEncryptionKeyLength As Object, Optional PasswordEncryptionFileProperties As Object)

Parameters

PasswordEncryptionProvider: Object

Optional Object. A case sensitive string of the encryption provider.

PasswordEncryptionAlgorithm: Object

Optional Object. A case sensitive string of the algorithmic short name (i.e. "RC4").

PasswordEncryptionKeyLength: Object

Optional Object. The encryption key length which is a multiple of 8 (40 or greater).

PasswordEncryptionFileProperties: Object

Optional Object. True (default) to encrypt file properties.

Remarks

The PasswordEncryptionProvider, PasswordEncryptionAlgorithm, and PasswordEncryptionKeyLength arguments 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 argument 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.

Applies to