Options¦Spelling

Home Search Site Map

Up
Options¦Calculation
Options¦Chart
Options¦Color
Options¦Custom Lists
Options¦Edit
Options¦Error Checking
Options¦General
Options¦International
Options¦Save
Options¦Security
Options¦Spelling
Options¦Transitions
Options¦View

New! Excel User Group Now Open @ www.excelusergroup.org,

UK EXCEL USER CONFERENCE - LONDON, UK. APRIL 1st/2nd 2009 - TOTALLY FREE - DETAILS CAN BE CHECKED OUT HERE! Check It Out!


Menu command Type What happens next?
Spelling Tab

All spelling and grammar checking options are here. You can select the dictionary to use for you language, the file that collects words that you 'add' whilst spell checking. (Your custom dictionary) and gives several options to ignore spelling errors in certain cases. You can also access the 'Auto Correct' options from here by pressing the button.

The right-hand side of the dialog is only enabled with certain language selections and set rules for those particular languages.

In the main, you should not need to make changes here as they are picked up from Window's language settings, but is nice to have the ability to switch if you are working in more than one language.

VBA Sub SetSpellingOptions()
With Application.SpellingOptions
.IgnoreCaps = True
.IgnoreFileNames = True
.IgnoreMixedDigits = True
.SuggestMainOnly = True
End With
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.