_Worksheet.Visible Property

Determines whether the object is visible. Read/write XlSheetVisibility.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Property Visible As XlSheetVisibility
Dim instance As _Worksheet
Dim value As XlSheetVisibility

value = instance.Visible

instance.Visible = value

The Visible property for a PivotTable item is True if the item is currently visible in the table.

If you set the Visible property for a name to False, the name won't appear in the Define Name dialog box.