Workbook.PersonalViewListSettings Property (Excel)
True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean.
Syntax
식 .PersonalViewListSettings
식 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.
With Workbooks(2)
.PersonalViewListSettings = False
.PersonalViewPrintSettings = False
End With