AutoCorrect.DisplayAutoCorrectOptions Property

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

See also:

• AutoCorrect Object
• AutoCorrect Object Members