SpellingOptions.IgnoreCaps Property (Excel)
False instructs Microsoft Excel to check for uppercase words, True instructs Excel to ignore words in uppercase when using the spelling checker. Read/write Boolean.
Syntax
expression .IgnoreCaps
expression A variable that represents a SpellingOptions object.
Example
In this example, Microsoft Excel determines what the setting is for checking the spelling of uppercase words and notifies the user.
Sub SpellingOptionsCheck()
If Application.SpellingOptions.IgnoreCaps = True Then
MsgBox "Spelling options for checking uppercase words is disabled."
Else
MsgBox "Spelling options for checking uppercase words is enabled."
End If
End Sub