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