AutoCorrect.DisplayAutoCorrectOptions Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub CheckDisplaySetting()

'Determine setting and notify user.
If Application.AutoCorrect.<strong>DisplayAutoCorrectOptions</strong> = 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