Workbook.PasswordEncryptionAlgorithm Property

  • Article
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