SuggestMainOnly Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

When set to True, instructs Microsoft Excel to suggest words from only the main dictionary, for using the spelling checker. False removes the limits of suggesting words from only the main dictionary, for using the spelling checker. Read/write Boolean.

expression.SuggestMainOnly

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

Example

In this example, Microsoft Excel checks the spell checking options for suggesting words only from the main dictionary and reports the status to the user.

  Sub UsingMainDictionary()

    ' Check the setting of suggesting words only from the main dictionary.
    If Application.SpellingOptions.SuggestMainOnly = True Then
        MsgBox "Spell checking option suggestions will only come from the main dictionary."
    Else
        MsgBox "Spell checking option suggestions are not limited to the main dictionary."
    End If

End Sub