New Methods (by Object)

   

In Microsoft Excel 2002, many new Visual Basic for Applications methods have been added to existing objects. These methods are listed in the following table (sorted by object name).

Objects Methods
AllowEditRange
ChangePassword
Application
CalculateFullRebuild
CheckAbort
ColorFormat
SetCMYK
CubeField
AddMemberPropertyField
CubeFields
AddSet
Diagram
Convert
DiagramNode
AddNode
CloneNode
MoveNode
NextNode
PrevNode
ReplaceNode
SwapNode
TransferChildren
DiagramNodeChildren
AddNode
IRtdServer
ConnectData
DisconnectData
Heartbeat
RefreshData
ServerStart
ServerTerminate
IRTDUpdateEvent
Disconnect
UpdateNotify
PivotCache
MakeConnection
SaveAsODC
PivotField
AddPageItem
PivotTable
AddDataField
CreateCubeFile
GetPivotData
QueryTable
SaveAsODC
Range
Dirty
Speak
RTD
RefreshData
RestartServers
Shapes
AddDiagram
SmartTagAction
Execute
Speech
Speak
UserAccessList
DeleteAll
Workbook
BreakLink
CanCheckIn
CheckIn
EndReview
RecheckSmartTags
ReplyWithChanges
SendForReview
SetPasswordEncryptionOptions
Workbooks
CanCheckOut
CheckOut
DiscardConflict
OfflineConflict
OpenDatabase
OpenXML
WorksheetFunction
RTD