| ERLANDSEN DATA CONSULTING |
Excel & VBA Tips
|
These pages are no longer updated and are only available for archive purposes.
Click here to visit the pages with updated information.
| Document: | Description: | Sort by date |
| Change the availability for a menu item | Enable or disable menu items. | 2000-02-05 |
| Change the availability for the CommandBars | Toggle the availability of CommandBars such as the Workbook Menu Bar, the Standard toolbar and custom CommandBars. | 2000-02-05 |
| Change the availability for the shortcut menus | Enable or disable shortcutmenus. | 2000-02-05 |
| Change the state of a custom CommandBar button | Change the state of a custom CommandBar button so it displays as depressed or not. | 2000-02-05 |
| Custom menus in Excel5/95 | With macros it's possible to create your own custom menu. In Excel-versions previous to Excel97 it's also possible to create menus with a built-in menu editor, but this option doesn't exist in Excel97. | 2000-02-05 |
| Custom menus in Excel97 and later | In Excel97 and later, menus and toolbarbuttons can be manipulated with the CommandBar-object. | 2000-02-05 |
| Determine which CommandBar button that started a macro | Let the macros themselves determine which CommandBar button that started them. | 2000-07-31 |
| Display a CommandBar centered on the screen | Display a CommandBar centered on the screen, both horizontally and vertically. | 2000-02-05 |
| Edit the tooltip for toolbarbuttons (Office95 and earlier) | Change the tooltip text for both built-in controls and custom buttons. | 2000-02-05 |
| Edit the tooltip for toolbarbuttons (Office97 and later) | Change the tooltip text for both built-in controls and custom buttons. | 2000-02-05 |
| Pass arguments to macros from buttons and menus | Create CommandBar buttons/menus that passes one or more arguments to a macro. | 2000-02-05 |
|
Erlandsen Data Consulting
http://www.erlandsendata.no/
Excel & VBA Tips Copyright ©1999-2024 Ole P. Erlandsen All rights reserved 
|