Application.DisplayInsertOptions Property (Excel)

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

Syntax

expression .DisplayInsertOptions

expression A variable that represents an Application object.

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

See Also

Concepts

Application Object

Application Object Members