Objects that have been hidden in the Microsoft Excel 97 Visual Basic object model are listed in the following table. These objects are supported only for backward compatibility; for new code, you should use the replacement functionality provided in Microsoft Excel 97. To view hidden objects in the Object Browser, right-click in the Object Browser window and click Show Hidden Members on the shortcut menu. For more information about the changes to the Microsoft Excel 97 object model, see one of the following topics:
New Properties and Methods (by Object)
New Properties and Methods (Alphabetic List)
Changes to Visual Basic in Microsoft Excel for Windows 95
Hidden objects | Replacement |
---|---|
Arc, Arcs, Drawing, DrawingObjects, Drawings, Label, Labels, Line, Lines, Oval, Ovals, Picture, Pictures, Rectangle, Rectangles | New Shapes drawing layer |
Button, Buttons, CheckBox, CheckBoxes, DialogFrame, DropDown, DropDowns, EditBox, EditBoxes, GroupBox, GroupBoxes, GroupObject, GroupObjects, ListBox, ListBoxes, OptionButton, OptionButtons, ScrollBar, ScrollBars, Spinner, Spinners, TextBox, TextBoxes | ActiveX controls |
Menu, MenuBar, MenuBars, MenuItem, MenuItems, Menus, Toolbar, ToolbarButton, ToolbarButtons, Toolbars | Command bars |
Module, Modules | VBE extensibility object model |
DialogSheet, DialogSheets | Custom forms |