Workbook.PersonalViewListSettings Property

  • Article
Excel Developer Reference

True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean.

Syntax

expression.PersonalViewListSettings

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