DisplayAutoCorrectOptions Property

Microsoft Excel Visual Basic

DisplayAutoCorrectOptions Property

       

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

expression.DisplayAutoCorrectOptions

expression   Required. An expression that returns one of the objects in the Applies To list.

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