共用方式為


Workbook.InactiveListBorderVisible Property (Excel)

A Boolean value that specifies whether list borders are visible when a list is not active. Returns True if the border is visible. Read/write Boolean.

Syntax

expression .InactiveListBorderVisible

expression A variable that represents a Workbook object.

Remarks

Setting this property will affect all the lists that are on the worksheet.

Example

The following example hides the borders of inactive lists in the workbook.

Sub HideListBorders() 
 
 ActiveWorkbook.InactiveListBorderVisible = False 
 
End Sub

請參閱

概念

Workbook Object

Workbook Object Members