Excel.Workbook.PasswordEncryptionKeyLength.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.PasswordEncryptionKeyLength property (Excel)	vbaxl10.chm199213	vbaxl10.chm199213	Excel.Workbook.PasswordEncryptionKeyLength	2662f2f5-1ad0-4a75-82c0-3268f147948a	05/29/2019	medium

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.

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.

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

[!includeSupport and feedback]