PersonalViewListSettings Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Workbook Object

See Also | AutoUpdateFrequency Property | MultiUserEditing Property | PersonalViewPrintSettings Property | SaveAs Method