Speiiing Options Object

This object represents the various spell-checking options for a worksheet. Spelling options can also be set manually on the Spelling tab in the Options dialog box. The following procedure sets some spelling options and adds a new dictionary named Special.dic, where you can add correct words found during the spell check. Use the following spreadsheet for the test run.

Licorice Root Tablets' _ 100

Sub SpellCheck()

' set spelling options With Application.SpellingOptions .SuggestMainOnly = True .IgnoreCaps = True .IgnoreMixedDigits = True .SuggestMainOnly = False .IgnoreFileNames = True .UserDict = "Special.dic" End With

' run a spell check Cells.CheckSpelling End Sub

0 0

Post a comment