Changes to the Microsoft Excel 97 Object Model

See Also

Extensive changes have been made to the Microsoft Excel 97 Visual Basic object model to support new and improved features in the application. Many objects, properties, and methods have been replaced. To provide backward compatibility, most of the replaced components have been hidden rather than removed. This means that they don't show up in the Object Browser by default, but old code that uses the hidden components will still work correctly without modification. When you write new code, however, you should use the new objects, properties, and methods.

The major Visual Basic feature changes in Microsoft Excel 97 are listed in the following table.

Feature Description
Shapes Replaces the drawing layer (Arc, Oval, Line, and so on) with a consistent and improved object model in all Microsoft Office applications.
UserForms, ActiveX controls Provides a consistent and expandable control and dialog box interface in all Microsoft Office applications.
CommandBars Provides a consistent and expandable menu and toolbar interface in all Microsoft Office applications.

For more information, see one of the following topics:

New Objects

New Properties and Methods (by Object)

New Properties and Methods (Alphabetic List)

Hidden Objects

Hidden Properties and Methods

Methods with New Arguments

Changes to Visual Basic in Microsoft Excel for Windows 95