The status bar in excel can be used as a code monitor. When your VBA code is lengthy and you do several tasks using VBA, you often disable the screen ...
The example below shows how you can create CommandBar buttons/menus that passes one or more arguments to a macro. the example also shows how you can ...
The examples below uses the New-button on the Standard toolbar as an example. You can replace "Standard" with the name or number of another CommandBa...
With the macro below, you can display a CommandBar centered on the screen, both horizontally and vertically. The macro also shows how you can get the...
Let the macros themselves determine which CommandBar button that started them. If you attach the macro below to multiple CommandBar buttons, the mess...
The macro below shows how you can change the state of a custom CommandBar button so it displays as depressed or not. Sub ToggleButtonState() Dim m A...
The macro below shows how you can toggle the availability state for the shortcut menus. Sub ToggleCommandBars() Dim cbEnabled As Boolean cbEnab...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
