Workbook.RemovePersonalInformation Property (Excel)
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.
Sub UsePersonalInformation()
Dim wkbOne As Workbook
Set wkbOne = Application.ActiveWorkbook
' Determine settings and notify user.
If wkbOne.RemovePersonalInformation = True Then
MsgBox "Personal information can be removed."
Else
MsgBox "Personal information cannot be removed."
End If
End Sub