Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
For upcoming training course dates see: Pricing & availability
RE: 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
Tue 18 May 2010: Automatically marked as resolved.
|
