Excel – Enable Disable Commands & Options
There are about 150+ options available with the code presented in this section.
The notable options are “Status Bar” and the Popup menu that appears when you right click on a cell or row etc.,
Using this code, those options can be switched on and off.VBA code to Switch on off Excel Command BarsVisual Basic123456789101112131415Sub List_Command_Bars()'Code by - firstname.lastname@example.orgDim c As CommandBar, i As Doublei = 1For Each c In CommandBarsIf VBA.Trim(c.Name) <> "" ThenThisWorkbook.Sheets(1).Cells(i, 1) = c.NameThisWorkbook.Sheets(1).Cells(i, 2) = c.EnabledThisWorkbook.Sheets(1).Cells(i, 3) = c.VisibleThisWorkbook.Sheets(1).Cells(i, 4) = c.Indexi = i + 1End IfNextEnd Sub
But remember that not all the commands are available to change the value. There are certain values like default Excel Worksheet menu. This cannot be switch off. Otherwise Excel will not work properly.
Similarly there are few option that we can play around with this VBA code.
Enable Disable Excel Command-Bar Options
- Block Apps in FaceBook print screen Excel Countif Record Macro Timer in Excel Task Manager VCF HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp Wordpress python