PersonalViewListSettings Property

Microsoft Excel Visual Basic

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

Example

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

With Workbooks(2)
    .PersonalViewListSettings = False
    .PersonalViewPrintSettings = False
End With