Workbook.PasswordEncryptionKeyLength Property

  • Article
Excel Developer Reference

Returns a Long indicating the key length of the algorithm Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only.

Syntax

expression.PasswordEncryptionKeyLength

expression   A variable that represents a Workbook object.

Remarks

Use the SetPasswordEncryptionOptions method to specify whether Excel encrypts file properties for the specified password-protected workbook.

Example

This example sets the password encryption options for the specified workbook, if the password encryption key length is less than 56.

Visual Basic for Applications 
  Sub SetPasswordOptions()

With ActiveWorkbook
    If .<strong class="bterm">PasswordEncryptionKeyLength</strong> &lt; 56 Then
        .SetPasswordEncryptionOptions _
            PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _
            PasswordEncryptionAlgorithm:="RC4", _
            PasswordEncryptionKeyLength:=56, _
            PasswordEncryptionFileProperties:=True
    End If
End With



End Sub

See Also