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 .


expression. InactiveListBorderVisible

expression A variable that represents a Workbook object.


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


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

Sub HideListBorders() 
 ActiveWorkbook.InactiveListBorderVisible = False 
End Sub

See also

Workbook Object