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.RemovePersonalInformation = True Then MsgBox "Personal information can be removed." Else MsgBox "Personal information cannot be removed." End If End Sub
remove remove personal information removepersonal RemovePersonalInformation RemovePersonalInformation Property

See also: