共用方式為


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

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

請參閱

概念

Workbook Object

Workbook Object Members