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 Google PlusVisit Us On Youtube