Workbook.RemovePersonalInformation Property

  • Article
Excel Developer Reference

True if personal information can be removed from the specified workbook. The default value is False. Read/write Boolean.

Syntax

expression.RemovePersonalInformation

expression   A variable that represents a Workbook object.

Example

In this example, Microsoft Excel determines if personal information can be removed from the specified workbook and notifies the user.

Visual Basic for Applications 
  Sub UsePersonalInformation()

Dim wkbOne As Workbook

Set wkbOne = Application.ActiveWorkbook

' Determine settings and notify user.
If wkbOne.<strong class="bterm">RemovePersonalInformation</strong> = True Then
    MsgBox "Personal information can be removed."
Else
    MsgBox "Personal information cannot be removed."
End If



End Sub

See Also