Excel

Hi Manoj, thanks for your query. There is no specific "Command" toolbar, did you have a specific one in mind? On our course we turned off the PivotTable toolbar with the following line of code:

Application.CommandBars("PivotTable").Visible = False

You can switch whichever toolbar you want on and off by simply substituting the text in the quotes for the corresponding name of the toolbar (which you can copy straight from the View-Toolbars menu options in Excel.

Hope this helps, and all the best!

Anthony