Excel.Workbook.InactiveListBorderVisible.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.InactiveListBorderVisible property (Excel)	vbaxl10.chm199229	vbaxl10.chm199229	Excel.Workbook.InactiveListBorderVisible	a6259862-9a29-f3a5-498f-633f51ec10e6	05/29/2019	medium

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 affects 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

[!includeSupport and feedback]