Microsoft Office Tutorials and References
In Depth Information
Figure G-1. The Error Checking tab
SpellingOptions Object
Path: Application - SpellingOptions
Object
Properties
ArabicModes() As XlArabicModes
DictLang() As Long
GermanPostReform() As Boolean
HebrewModes() As XlHebrewModes
IgnoreCaps() As Boolean
IgnoreFileNames() As Boolean
IgnoreMixedDigits() As Boolean
KoreanCombineAux() As Boolean
KoreanProcessCompound() As Boolean
KoreanUseAutoChangeList() As Boolean
SuggestMainOnly() As Boolean
UserDict() As String
SpellingOptions
The SpellingOptions object, returned by the SpellingOptions property of the Application object,
can set options for Excel's spell checking feature. The object has no methods, and its properties
generally correspond to the options available through the Spelling tab of Excel's Options dialog.
Tab Object
Path: Application -- Chart - Tab
Object
Properties
Color() As Variant
ColorIndex() As XlColorIndex
Tab
The ability to change the color of worksheet and chart tabs is new for Excel XP. This is done
through the user interface by right-clicking on a tab and choosing Tab Color from the popup menu.
To change the color programmatically, we can write code such as:
Worksheets("Sheet2").Tab.Color = vbGreen
The Tab object is returned by the Tab property of the Worksheet and the chart objects, and it has
Color and ColorIndex properties that can set the color.
UsedObjects Object
Path: Application - UsedObjects
Object
Properties
 
 
 
 
Search JabSto ::




Custom Search