DisplayInsertOptions Property

Microsoft Excel Visual Basic

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