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