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 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