InactiveListBorderVisible Property

Microsoft Excel Visual Basic

Show All Show All

InactiveListBorderVisible Property

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.

expression.InactiveListBorderVisible

expression    Required. An expression that returns one of the objects in the Applies To list.

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