Share via


Workbook.PasswordEncryptionAlgorithm Property

Excel Developer Reference

Returns a String indicating the algorithm 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.

Visual Basic for Applications
  Sub SetPasswordOptions()
ActiveWorkbook.SetPasswordEncryptionOptions _
    PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _
    <strong class="bterm">PasswordEncryptionAlgorithm</strong>:="RC4", _
    PasswordEncryptionKeyLength:=56, _
    PasswordEncryptionFileProperties:=True

End Sub

See Also