Workbook.PasswordEncryptionKeyLength property (Excel)

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



expression A variable that represents a Workbook object.


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


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, _ 
 End If 
 End With 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.