DisplayInsertOptions Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Application Object