Share via

Workbook.PersonalViewPrintSettings Property

  • Article
Excel Developer Reference

True if print settings are included in the user's personal view of the shared workbook. Read-write Boolean.

Syntax

expression.PersonalViewPrintSettings

expression   A variable that represents a Workbook object.

Example

This example removes print settings and filter and sort settings from the user's personal view of workbook two.

Visual Basic for Applications 
  With Workbooks(2)
    .PersonalViewListSettings = False
    .PersonalViewPrintSettings = False
End With

See Also