Edit

Share via

Workbook.RemovePersonalInformation property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.