Workbook.InactiveListBorderVisible Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub HideListBorders()

ActiveWorkbook.<strong>InactiveListBorderVisible</strong> = False



End Sub

See Also