The macro below shows how you can toggle the availability state for the shortcut menus. Sub ToggleCommandBars() Dim cbEnabled As Boolean cbEnab...
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...
The macro below shows how you can toggle the availability state for a menu item. Sub ToggleMenuControls() Dim m As CommandBarControl, mi As CommandB...
In this article we will learn how to activate full-screen feature and disable window resize button using VBA. Logic explanation We have created â€...
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...
In this article, we will use before double click event of the worksheet to check and uncheck the cell. Raw data consists of some food items. We want ...
This is good if you like to use statements like Range("A1") instead of cells(1,1). So, for example ColLetter(1) = A, ColLetter(2) = b, ... , ColLet...
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.
