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.

expression .IgnoreCaps

expression A variable that represents a SpellingOptions object.

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
Show:
© 2015 Microsoft