Workbook.PasswordEncryptionKeyLength Property (Excel)
Returns a Long indicating the key length of the algorithm Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only.
Syntax
식 .PasswordEncryptionKeyLength
식 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.
Sub SetPasswordOptions()
With ActiveWorkbook
If .PasswordEncryptionKeyLength < 56 Then
.SetPasswordEncryptionOptions _
PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _
PasswordEncryptionAlgorithm:="RC4", _
PasswordEncryptionKeyLength:=56, _
PasswordEncryptionFileProperties:=True
End If
End With
End Sub