Workbook.PasswordEncryptionProvider Property

Syntax

expression.PasswordEncryptionProvider

expression A variable that represents a Workbook object.

Example

This example sets the password encryption options for the specified workbook, if the file properties are not encrypted for password-protected workbooks.

Visual Basic for Applications

Visual Basic for Applications
`Sub SetPasswordOptions() With ActiveWorkbook If .PasswordEncryptionProvider <> "Microsoft RSA SChannel Cryptographic Provider" Then .SetPasswordEncryptionOptions _ PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _ PasswordEncryptionAlgorithm:="RC4", _ PasswordEncryptionKeyLength:=56, _ PasswordEncryptionFileProperties:=True End If End With End Sub`

Sub SetPasswordOptions() With ActiveWorkbook If .PasswordEncryptionProvider <> "Microsoft RSA SChannel Cryptographic Provider" Then .SetPasswordEncryptionOptions _ PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _ PasswordEncryptionAlgorithm:="RC4", _ PasswordEncryptionKeyLength:=56, _ PasswordEncryptionFileProperties:=True End If End With End Sub

password password encryption provider passwordencryption passwordencryptionprovider passwordencryptionprovider property

Workbook.PasswordEncryptionProvider Property

Returns a String specifying the name of the algorithm encryption provider that Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only.

See also: