다음을 통해 공유


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

참고 항목

개념

Workbook Object

Workbook Object Members