Edit

Share via

Workbook.PasswordEncryptionAlgorithm property (Excel)

  • Article

Returns a String indicating the algorithm that Microsoft Excel uses to encrypt passwords for the specified workbook. Read-only.

Syntax

expression.PasswordEncryptionAlgorithm

expression A variable that represents a Workbook object.

Remarks

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

Example

This example sets the password encryption options for the active workbook.

Sub SetPasswordOptions() 
 
 ActiveWorkbook.SetPasswordEncryptionOptions _ 
 PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _ 
 PasswordEncryptionAlgorithm:="RC4", _ 
 PasswordEncryptionKeyLength:=56, _ 
 PasswordEncryptionFileProperties:=True 
 
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.