Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean.
Syntax
expression .PersonalViewListSettings
expression 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