DisplayInsertOptions Property

Microsoft Excel Visual Basic

DisplayInsertOptions Property

       

True if the Insert Options button should be displayed. Read/write Boolean.

expression.DisplayInsertOptions

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

In this example, Microsoft Excel notifies the user the status of displaying the Insert Options button.

Sub SettingToolTip()

    ' Notify the user of the ToolTip status.
    If Application.DisplayInsertOptions = True Then
        MsgBox "The ability to display the Insert Options button is on."
    Else
        MsgBox "The ability to display the Insert Options button is off."
    End If

End Sub