SpellingOptions.SuggestMainOnly Property (Excel)
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.
Syntax
expression .SuggestMainOnly
expression A variable that represents a SpellingOptions object.
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