Workbook.PasswordEncryptionFileProperties Property

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

See also:

• Workbook Object
• Workbook Object Members