Excel Control Objects

AppEvents (1997) Hidden or unsupported element.

NewWorkbook(Wb)
SheetActivate(Sh)
SheetBeforeDoubleClick(Sh, Target, Cancel)
SheetBeforeRightClick(Sh, Target, Cancel)
SheetCalculate(Sh)
SheetChange(Sh, Target)
SheetDeactivate(Sh)
SheetFollowHyperlink(Sh, Target)
SheetPivotTableUpdate(Sh, Target)
SheetSelectionChange(Sh, Target)
WindowActivate(Wb, Wn)
WindowDeactivate(Wb, Wn)
WindowResize(Wb, Wn)
WorkbookActivate(Wb)
WorkbookAddinInstall(Wb)
WorkbookAddinUninstall(Wb)
WorkbookAfterXmlExport(Wb, Map, Url, Result)
WorkbookAfterXmlImport(Wb, Map, IsRefresh, Result)
WorkbookBeforeClose(Wb, Cancel)
WorkbookBeforePrint(Wb, Cancel)
WorkbookBeforeSave(Wb, SaveAsUI, Cancel)
WorkbookBeforeXmlExport(Wb, Map, Url, Cancel)
WorkbookBeforeXmlImport(Wb, Map, Url, IsRefresh, Cancel)
WorkbookDeactivate(Wb)
WorkbookNewSheet(Wb, Sh)
WorkbookOpen(Wb)
WorkbookPivotTableCloseConnection(Wb, Target)
WorkbookPivotTableOpenConnection(Wb, Target)
WorkbookSync(Wb, SyncEventType)

Application (1995) Represents the entire Microsoft Excel application.

ActivateMicrosoftApp(Index)
ActiveCell
ActiveChart
ActiveDialog
ActiveMenuBar
ActivePrinter [= setting]
ActiveSheet
ActiveWindow
ActiveWorkbook
AddChartAutoFormat(Chart, Name, [Description])
AddCustomList(ListArray, [ByRow])
AddIns
AlertBeforeOverwriting [= setting]
AltStartupPath [= setting]
AnswerWizard
AppEvents_Event_NewWorkbook
Application
ArbitraryXMLSupportAvailable
AskToUpdateLinks [= setting]
Assistant
AutoCorrect
AutoFormatAsYouTypeReplaceHyperlinks [= setting]
AutomationSecurity [= setting]
AutoPercentEntry [= setting]
AutoRecover
Build
Calculate()
CalculateBeforeSave [= setting]
CalculateFull()
CalculateFullRebuild()
Calculation [= setting]
CalculationInterruptKey [= setting]
CalculationState
CalculationVersion
Caller
CanPlaySounds
CanRecordSounds
Caption [= setting]
CellDragAndDrop [= setting]
Cells
CentimetersToPoints(Centimeters)
Charts
CheckAbort([KeepAbort])
CheckSpelling(Word, [CustomDictionary], [IgnoreUppercase])
ClipboardFormats
ColorButtons [= setting]
Columns
COMAddIns
CommandBars
CommandUnderlines [= setting]
ConstrainNumeric [= setting]
ControlCharacters [= setting]
ConvertFormula(Formula, FromReferenceStyle, [ToReferenceStyle], [ToAbsolute], [RelativeTo])
CopyObjectsWithCells [= setting]
CreateObjRef(requestedType)
Creator
Cursor [= setting]
CursorMovement [= setting]
CustomListCount
CutCopyMode [= setting]
DataEntryMode [= setting]
DDEAppReturnCode
DDEExecute(Channel, String)
DDEInitiate(App, Topic)
DDEPoke(Channel, Item, Data)
DDERequest(Channel, Item)
DDETerminate(Channel)
DecimalSeparator [= setting]
DefaultFilePath [= setting]
DefaultSaveFormat [= setting]
DefaultSheetDirection [= setting]
DefaultWebOptions
DeleteChartAutoFormat(Name)
DeleteCustomList(ListNum)
Dialogs
DialogSheets
DisplayAlerts [= setting]
DisplayClipboardWindow [= setting]
DisplayCommentIndicator [= setting]
DisplayDocumentActionTaskPane [= setting]
DisplayExcel4Menus [= setting]
DisplayFormulaBar [= setting]
DisplayFullScreen [= setting]
DisplayFunctionToolTips [= setting]
DisplayInfoWindow [= setting]
DisplayInsertOptions [= setting]
DisplayNoteIndicator [= setting]
DisplayPasteOptions [= setting]
DisplayRecentFiles [= setting]
DisplayScrollBars [= setting]
DisplayStatusBar [= setting]
DisplayXMLSourcePane([XmlMap])
DoubleClick()
Dummy1([Arg1], [Arg2], [Arg3], [Arg4])
Dummy10([arg])
Dummy101
Dummy11()
Dummy12(p1, p2)
Dummy13(Arg1, [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
Dummy14()
Dummy2([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8])
Dummy3()
Dummy4([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15])
Dummy5([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13])
Dummy6()
Dummy7()
Dummy8([Arg1])
Dummy9()
EditDirectlyInCell [= setting]
EnableAnimations [= setting]
EnableAutoComplete [= setting]
EnableCancelKey [= setting]
EnableEvents [= setting]
EnableSound [= setting]
EnableTipWizard [= setting]
Equals(obj)
ErrorCheckingOptions
Evaluate(Name)
Excel4IntlMacroSheets
Excel4MacroSheets
ExecuteExcel4Macro(String)
ExtendList [= setting]
FeatureInstall [= setting]
FileConverters
FileDialog
FileFind
FileSearch
FindFile()
FindFormat [= setting]
FixedDecimal [= setting]
FixedDecimalPlaces [= setting]
GenerateGetPivotData [= setting]
GetCustomListContents(ListNum)
GetCustomListNum(ListArray)
GetHashCode()
GetLifetimeService()
GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText], [MultiSelect])
GetPhonetic([Text])
GetSaveAsFilename([InitialFilename], [FileFilter], [FilterIndex], [Title], [ButtonText])
GetType()
Goto([Reference], [Scroll])
Height [= setting]
Help([HelpFile], [HelpContextID])
Hinstance
Hwnd
IgnoreRemoteRequests [= setting]
InchesToPoints(Inches)
InitializeLifetimeService()
InputBox(Prompt, [Title], [Default], [Left], [Top], [HelpFile], [HelpContextID], [Type])
Interactive [= setting]
International
Intersect(Arg1, Arg2, [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
Iteration [= setting]
LanguageSettings
LargeButtons [= setting]
Left [= setting]
LibraryPath
MacroOptions([Macro], [Description], [HasMenu], [MenuText], [HasShortcutKey], [ShortcutKey], [Category], [StatusBar], [HelpContextID], [HelpFile])
MailLogoff()
MailLogon([Name], [Password], [DownloadNewMail])
MailSession
MailSystem
MapPaperSize [= setting]
MathCoprocessorAvailable
MaxChange [= setting]
MaxIterations [= setting]
MemoryFree
MemoryTotal
MemoryUsed
MenuBars
Modules
MouseAvailable
MoveAfterReturn [= setting]
MoveAfterReturnDirection [= setting]
Name
Names
NetworkTemplatesPath
NewWorkbook
NextLetter()
ODBCErrors
ODBCTimeout [= setting]
OLEDBErrors
OnCalculate [= setting]
OnData [= setting]
OnDoubleClick [= setting]
OnEntry [= setting]
OnKey(Key, [Procedure])
OnRepeat(Text, Procedure)
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
OnTime(EarliestTime, Procedure, [LatestTime], [Schedule])
OnUndo(Text, Procedure)
OnWindow [= setting]
OperatingSystem
OrganizationName
Parent
Path
PathSeparator
PivotTableSelection [= setting]
PreviousSelections
ProductCode
PromptForSummaryInfo [= setting]
Quit()
Range
Ready
RecentFiles
RecordMacro([BasicCode], [XlmCode])
RecordRelative
ReferenceStyle [= setting]
RegisteredFunctions
RegisterXLL(Filename)
Repeat()
ReplaceFormat [= setting]
ResetTipWizard()
RollZoom [= setting]
Rows
RTD
Run([Macro], [Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
Save([Filename])
SaveWorkspace([Filename])
ScreenUpdating [= setting]
Selection
SendKeys(Keys, [Wait])
SetDefaultChart([FormatName], [Gallery])
SheetActivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
SheetPivotTableUpdate
Sheets
SheetSelectionChange
SheetsInNewWorkbook [= setting]
ShortcutMenus
ShowChartTipNames [= setting]
ShowChartTipValues [= setting]
ShowStartupDialog [= setting]
ShowToolTips [= setting]
ShowWindowsInTaskbar [= setting]
SmartTagRecognizers
Speech
SpellingOptions
StandardFont [= setting]
StandardFontSize [= setting]
StartupPath
StatusBar [= setting]
Support(Object, ID, [arg])
TemplatesPath
ThisCell
ThisWorkbook
ThousandsSeparator [= setting]
Toolbars
Top [= setting]
ToString()
TransitionMenuKey [= setting]
TransitionMenuKeyAction [= setting]
TransitionNavigKeys [= setting]
UILanguage [= setting]
Undo()
Union(Arg1, Arg2, [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
UsableHeight
UsableWidth
UsedObjects
UserControl [= setting]
UserLibraryPath
UserName [= setting]
UseSystemSeparators [= setting]
Value
VBE
Version
Visible [= setting]
Volatile([Volatile])
Wait(Time)
Watches
Width [= setting]
WindowActivate
WindowDeactivate
WindowResize
Windows
WindowsForPens
WindowState [= setting]
WorkbookActivate
WorkbookAddinInstall
WorkbookAddinUninstall
WorkbookAfterXmlExport
WorkbookAfterXmlImport
WorkbookBeforeClose
WorkbookBeforePrint
WorkbookBeforeSave
WorkbookBeforeXmlExport
WorkbookBeforeXmlImport
WorkbookDeactivate
WorkbookNewSheet
WorkbookOpen
WorkbookPivotTableCloseConnection
WorkbookPivotTableOpenConnection
Workbooks
WorkbookSync
WorksheetFunction
Worksheets

AutoCorrect (1995) Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).

AddReplacement(What, Replacement)
Application
AutoExpandListRange [= setting]
CapitalizeNamesOfDays [= setting]
CorrectCapsLock [= setting]
CorrectSentenceCap [= setting]
Creator
DeleteReplacement(What)
DisplayAutoCorrectOptions [= setting]
Parent
ReplacementList [= setting]
ReplaceText [= setting]
TwoInitialCapitals [= setting]

AutoRecover (2002) Use the Path property of the AutoRecover object to set the path for where the AutoRecover file will be saved. The following example sets the path of the AutoRecover file to drive C.

Application
Creator
Enabled [= setting]
Parent
Path [= setting]
Time [= setting]

CellFormat (2002) Represents the search criteria for the cell format.

AddIndent [= setting]
Application
Borders [= setting]
Clear()
Creator
Font [= setting]
FormulaHidden [= setting]
HorizontalAlignment [= setting]
IndentLevel [= setting]
Interior [= setting]
Locked [= setting]
MergeCells [= setting]
NumberFormat [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
ShrinkToFit [= setting]
VerticalAlignment [= setting]
WrapText [= setting]

ErrorCheckingOptions (2002) Represents the error-checking options for an application.

Application
BackgroundChecking [= setting]
Creator
EmptyCellReferences [= setting]
EvaluateToError [= setting]
InconsistentFormula [= setting]
IndicatorColorIndex [= setting]
ListDataValidation [= setting]
NumberAsText [= setting]
OmittedCells [= setting]
Parent
TextDate [= setting]
UnlockedFormulaCells [= setting]

Pane (1995) Represents a pane of a window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets. The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single window.

Activate()
Application
Creator
Index
LargeScroll([Down], [Up], [ToRight], [ToLeft])
Parent
ScrollColumn [= setting]
ScrollIntoView(Left, Top, Width, Height, [Start])
ScrollRow [= setting]
SmallScroll([Down], [Up], [ToRight], [ToLeft])
VisibleRange

Panes (1995) A collection of all the Pane objects shown in the specified window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets.

Application
Count
Creator
Item
Parent

RecentFile (1997) Represents a file in the list of recently used files. The RecentFile object is a member of the RecentFiles collection.

Application
Creator
Delete()
Index
Name
Open()
Parent
Path

RecentFiles (1997) Represents the list of recently used files. Each file is represented by a RecentFile object.

Add(Name)
Application
Count
Creator
GetEnumerator()
Item
Maximum [= setting]
Parent

Sheets (1995) A collection of all the sheets in the specified or active workbook. The Sheets collection can contain Worksheet objects.

Add([Before], [After], [Count], [Type])
Application
Copy([Before], [After])
Count
Creator
Delete()
FillAcrossSheets(Range, [Type])
GetEnumerator()
HPageBreaks
Item
Move([Before], [After])
Parent
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Select([Replace])
Visible [= setting]
VPageBreaks

Speech (2002) Hidden or unsupported element.

Direction [= setting]
Speak(Text, [SpeakAsync], [SpeakXML], [Purge])
SpeakCellOnEnter [= setting]

SpellingOptions (2002) Represents the various spell checking options for a worksheet.

ArabicModes [= setting]
DictLang [= setting]
GermanPostReform [= setting]
HebrewModes [= setting]
IgnoreCaps [= setting]
IgnoreFileNames [= setting]
IgnoreMixedDigits [= setting]
KoreanCombineAux [= setting]
KoreanProcessCompound [= setting]
KoreanUseAutoChangeList [= setting]
SuggestMainOnly [= setting]
UserDict [= setting]

Watch (2002) Represents a range which is tracked when the worksheet is recalculated. The Watch object allows users to verify the accuracy of their models and debug problems they encounter. The Watch object is a member of the Watches collection.

Application
Creator
Delete()
Parent
Source

Watches (2002) A collection of all the Watch objects in a specified application.

Add(Source)
Application
Count
Creator
Delete()
GetEnumerator()
Item
Parent

Window (1995) Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window. The Window object is a member of the Windows collection. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook.

Activate()
ActivateNext()
ActivatePrevious()
ActiveCell
ActiveChart
ActivePane
ActiveSheet
Application
Caption [= setting]
Close([SaveChanges], [Filename], [RouteWorkbook])
Creator
DisplayFormulas [= setting]
DisplayGridlines [= setting]
DisplayHeadings [= setting]
DisplayHorizontalScrollBar [= setting]
DisplayOutline [= setting]
DisplayRightToLeft [= setting]
DisplayVerticalScrollBar [= setting]
DisplayWorkbookTabs [= setting]
DisplayZeros [= setting]
EnableResize [= setting]
FreezePanes [= setting]
GridlineColor [= setting]
GridlineColorIndex [= setting]
Height [= setting]
Index
LargeScroll([Down], [Up], [ToRight], [ToLeft])
Left [= setting]
NewWindow()
OnWindow [= setting]
Panes
Parent
PointsToScreenPixelsX(Points)
PointsToScreenPixelsY(Points)
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
RangeFromPoint(x, y)
RangeSelection
ScrollColumn [= setting]
ScrollIntoView(Left, Top, Width, Height, [Start])
ScrollRow [= setting]
ScrollWorkbookTabs([Sheets], [Position])
SelectedSheets
Selection
SmallScroll([Down], [Up], [ToRight], [ToLeft])
Split [= setting]
SplitColumn [= setting]
SplitHorizontal [= setting]
SplitRow [= setting]
SplitVertical [= setting]
TabRatio [= setting]
Top [= setting]
Type
UsableHeight
UsableWidth
View [= setting]
Visible [= setting]
VisibleRange
Width [= setting]
WindowNumber
WindowState [= setting]
Zoom [= setting]

Windows (1995) A collection of all the Window objects in Microsoft Excel. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook.

Application
Arrange([ArrangeStyle], [ActiveWorkbook], [SyncHorizontal], [SyncVertical])
BreakSideBySide()
CompareSideBySideWith(WindowName)
Count
Creator
GetEnumerator()
Item
Parent
ResetPositionsSideBySide()
SyncScrollingSideBySide [= setting]