Workbook.PasswordEncryptionFileProperties Property

  • Article
Excel Developer Reference

True if Microsoft Excel encrypts file properties for the specified password-protected workbook. Read-only Boolean.

Syntax

expression.PasswordEncryptionFileProperties

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 if the file properties are not encrypted for password-protected workbooks.

Visual Basic for Applications 
  Sub SetPasswordOptions()

With ActiveWorkbook
    If .<strong class="bterm">PasswordEncryptionFileProperties</strong> = False Then
        .SetPasswordEncryptionOptions _
            PasswordEncryptionProvider:="Microsoft RSA SChannel Cryptographic Provider", _
            PasswordEncryptionAlgorithm:="RC4", _
            PasswordEncryptionKeyLength:=56, _
            PasswordEncryptionFileProperties:=True
    End If
End With



End Sub

See Also