AutoCorrect.DisplayAutoCorrectOptions property (Excel)

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


expression. DisplayAutoCorrectOptions

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

See also

AutoCorrect Object