Workbook.PasswordEncryptionProvider Property

  • Article
Excel Developer Reference

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

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 
  Sub SetPasswordOptions()

With ActiveWorkbook
    If .<strong class="bterm">PasswordEncryptionProvider</strong> &lt;&gt; "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

See Also