Determine which CommandBar button that started a macro using VBA in Microsoft Excel

Let the macros themselves determine which CommandBar button that started them. If you attach the macro below to multiple CommandBar buttons, the mess...

Change the state of a custom CommandBar button using VBA in Microsoft Excel

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...

Change the availability for the shortcut menus using VBA in Microsoft Excel

The macro below shows how you can toggle the availability state for the shortcut menus. Sub ToggleCommandBars() Dim cbEnabled As Boolean cbEnab...

Change the availability for the CommandBars using VBA in Microsoft Excel

With the macro below you can toggle the availability of the Workbook Menu Bar,the Standard toolbar and a custom CommandBar. The first time you run th...

Change the availability for a menu item using VBA in Microsoft Excel

The macro below shows how you can toggle the availability state for a menu item. Sub ToggleMenuControls() Dim m As CommandBarControl, mi As CommandB...

Activate full-screen feature and disable window resize button of an Excel workbook using VBA in Microsoft Excel.

In this article we will learn how to activate full-screen feature and disable window resize button using VBA. Logic explanation We have created â€...

Countdown in status bar using VBA in Microsoft Excel

If you are wondering how can I create timer in excel Question: A count down from 30 to 0 seconds is to be displayed in the status bar. Answe...

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube