excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

replyReply Sun 9 May 2010, 12:35Delegate Manoj said...

Manoj has attended:
Excel VBA Intro Intermediate course

Excel

How do I bring up the Command Toolbar?

For upcoming training course dates see: Pricing & availability

replyReply Wed 12 May 2010, 09:14Trainer Anthony said...

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.

 

Please browse our web site to find out more about
2000 access microsoft training and other Microsoft training courses.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard