SuggestMainOnly Property

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