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