ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

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
E-mail Contact Address