Hidden properties and methods for visible objects are listed in the following table. Most of the hidden properties and methods have been replaced by new functionality in Microsoft Excel 97. These properties and methods are supported only for backward compatibility; for new code, you should use the replacement functionality provided in Microsoft Excel 97. 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
| Objects | Hidden property or method | Replacement |
|---|---|---|
| Application | ActiveDialog | ActiveX controls |
| Application | ActiveMenuBar | CommandBars |
| Chart, Worksheet | Arcs | Shapes |
| AddIn, Workbook | Author | DocumentProperties |
| Chart | AutoFormat | ApplyCustomType method |
| Chart, Worksheet | Buttons | ActiveX controls |
| Chart, Worksheet | CheckBoxes | ActiveX controls |
| Application | ColorButtons | no replacement |
| AddIn, Workbook | Comments | DocumentProperties |
| Application, Workbook | DialogSheets | Custom Forms and ActiveX controls |
| Worksheet | DisplayAutomaticPageBreaks | DisplayPageBreaks Property |
| Application | DisplayInfoWindow | no replacement |
| Chart, Worksheet | DrawingObjects | Shapes |
| Chart, Worksheet | Drawings | Shapes |
| Chart, Worksheet | DropDowns | ActiveX controls |
| Application | EnableTipWizard | Assistant |
| ChartObjects, OLEObjects | Group | Shapes |
| Chart, Worksheet | GroupBoxes | Shapes |
| Chart, Worksheet | GroupObjects | Shapes |
| AddIn, Workbook | Keywords | DocumentProperties |
| Chart, Worksheet | Labels | Shapes |
| Application | LargeButtons | no replacement |
| Chart, Worksheet | Lines | Shapes |
| Chart, Worksheet | ListBoxes | ActiveX controls |
| Application | MenuBars | CommandBars |
| Application, Workbook | Modules | VBE |
| ChartObject, ChartObjects, OLEObject, OLEObjects | OnAction | Change or SheetChange event |
| Application, Worksheet | OnCalculate | Calculate event |
| Application, Worksheet | OnData | Change or SheetChange event |
| Application, Chart, Worksheet | OnDoubleClick | BeforeDoubleClick event |
| Application, Worksheet | OnEntry | Change event |
| Workbook | OnSave | BeforeSave event |
| Application, Chart, Workbook, Worksheet | OnSheetActivate | Activate or SheetActivate event |
| Application, Chart, Workbook, Worksheet | OnSheetDeactivate | Deactivate or SheetDeactivate events |
| Chart, Worksheet | OptionButtons | ActiveX controls |
| Chart, Worksheet | Ovals | ActiveX controls |
| Chart, Worksheet | Pictures | Shapes |
| Chart, Worksheet | Rectangles | Shapes |
| Application | ResetTipWizard | Assistant |
| Application | Save | SaveWorkspace Method |
| Chart, Worksheet | ScrollBars | ActiveX controls |
| Window | SetInfoDisplay | no replacement |
| Application | ShortcutMenus | CommandBars |
| Chart, Worksheet | Spinners | ActiveX controls |
| AddIn, Workbook | Subject | DocumentProperties |
| Chart, ChartGroup | SubType | ChartType property |
| Chart, Worksheet | TextBoxes | ActiveX controls |
| AddIn, Workbook | Title | DocumentProperties |
| Application | Toolbars | CommandBars |
| Chart, ChartGroup | Type | ChartType property |