-
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.
123456789101112131415Sub List_Command_Bars()'Code by - author@officetricks.comDim 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.
Previous Post: VBA File Open Dialog Box
Next Post: How to Play Fortnite Game?
