Application.DisplayInsertOptions property (Excel)

  • Article

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 of the status of displaying the Insert Options button.

Sub SettingToolTip() 
 
 ' Notify the user of the ability to display the Insert Options button. 
 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.