PersonalViewListSettings Property
Applies To
Workbook object.
Description
True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean.
See Also
AutoUpdateFrequency property, MultiUserEditing property, PersonalViewPrintSettings property, SaveAs method.
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