AutoCorrect.DisplayAutoCorrectOptions property (Excel)

Allows the user to display or hide the AutoCorrect Options button. The default value is True. Read/write Boolean.



expression A variable that represents an AutoCorrect object.


The DisplayAutoCorrectOptions property is a Microsoft Office-wide setting. Changing this property in Microsoft Excel will affect the other Office applications also.

In Excel, the AutoCorrect Options button only appears when a hyperlink is automatically created.


This example determines if the AutoCorrect Options button can be displayed, and notifies the user.

Sub CheckDisplaySetting() 
 'Determine setting and notify user. 
 If Application.AutoCorrect.DisplayAutoCorrectOptions = True Then 
 MsgBox "The AutoCorrect Options button can be displayed." 
 MsgBox "The AutoCorrect Options button cannot be displayed." 
 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.