Spreadsheet.DisplayAttribute

This property returns/sets the display status of a specified attribute (e.g., displaying marked cells).

Syntax Parameters Return Value
Property Spreadsheet.DisplayAttribute( _
    Attribute As SpreadsheetDisplayType) As Boolean
Attribute [in]

Type: SpreadsheetDisplayType

Boolean

SVB Example

Customizing display attributes:

Option Base 1
Option Explicit
Sub Main
    'toggle various display attributes of the spreadsheet
    ActiveSpreadsheet.DisplayAttribute(scDisplayVariableNumbers) = False
    ActiveSpreadsheet.DisplayAttribute(scDisplayIgnoreEmptyCaseNames) = True
    ActiveSpreadsheet.DisplayAttribute(scDisplayHeader) = False
End Sub