AutoCorrect.DisplayAutoCorrectOptions Property (Excel)

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

Syntax

expression. DisplayAutoCorrectOptions

expression A variable that represents an [AutoCorrect](Excel.AutoCorrect(Graph property).md) object.

Remarks

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.

Example

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." 
 Else 
 MsgBox "The AutoCorrect Options button cannot be displayed." 
 End If 
 
End Sub

See also

AutoCorrect Object