Show Vba Toolbar Excel 2010

How to Add the Developer Toolbar to Excel

Before you can make a start, you need to add the Developer ribbon to the top of Excel.

If you have Excel 2007, click the round Office button, then click Excel Options at the bottom. When you get the Options dialogue box up, click on Popular from the left in 2007. In the section labelled "Top options for working with Excel" check the box for "Show Developer tab in the Ribbon":

the Popular tab">

In Excel 2010 to 2016 click theFilemenu then selectOptions. From the dialogue box, click onCustomize Ribbonon the left side. From the right hand side you’ll then see an area called "Customize the Ribbon". Under "Main Tabs" check the box forDeveloper:

When you have the developer toolbar, you’ll see the following tab in the Ribbon (this is from Excel 2013, so you may not have all the items below):

In order to run macros without any annoying security warnings, click onMacro Security, on theCodepanel. Select the option forEnable all macros. Then make sure that "Trust access to the VBA object model" is checked:

NOTE: If you’re worried about macro security then you can always bring this box up again and disable the macros before you exit Excel.

Now that you have the developer tab added to the Ribbon you can do things like bring up the Visual Basic Editor, run macros, record macros, and insert form objects onto your spreadsheets. First, let’s have a look at the Visual Basic Development Environment. This is, after all, where you’ll be writing all your code.

Home and Learn Books

All course material copyright:
Ken Carney, Home and Learn

Show or hide the ribbon in Office

The ribbon is a set of toolbars at the top of the window in Office programs designed to help you quickly find the commands that you need to complete a task.

Show Ribbon options

At the top-right corner, select the Ribbon Display Options icon.

Choose an option for the ribbon:

Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.

Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.

Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select More, or press the ALT key.

Collapse the ribbon or expand it again

Double-click any of the ribbon tabs or press CTRL+F1 to collapse the ribbon if you need to see more of your document.

To see the ribbon again, just double-click any ribbon tab, or press CTRL+F1.

If the ribbon isn’t visible at all

If the ribbon isn’t visible at all (no tabs are showing), then you probably have it set to Auto-hide. Select Moreat the top right of the screen. This will temporarily restore the ribbon.

When you return to the document, the ribbon will be hidden again. To keep the ribbon displayed, select one of the Show options above.

See also

Minimize the ribbon

You can minimize the ribbon if you need to see more of the document you are creating. To collapse the ribbon, select the Minimize the Ribbon arrow at the top right.

To see the ribbon again, select the arrow again.

MS Excel 2010: Display the Developer tab in the toolbar

This Excel tutorial explains how to display the developer tab in the toolbar in Excel 2010 (with screenshots and step-by-step instructions).

See solution in other versions of Excel :

Question: In Microsoft Excel 2010, how do I get the Developer tab to display in the toolbar at the top of the screen?

The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.

Answer: To display the Developer tab, click on the File menu and then selectOptionsfrom the drop down menu.

When the Excel Options window appears, click on theCustomize Ribbonoption on the left. Click on theDevelopercheckbox under the list of Main Tabs on the right. Then click on the OK button.

Now you should see theDeveloper tabin the toolbar at the top of the screen. All of the Developer tab option groups should be available – Code, Add-Ins, Controls, XML, and Modify (see below).

Excel VBA Video Training / EXCEL DASHBOARD REPORTS

Show/Hide Custom Toolbars & Remove/Restore Excel’s Native Toolbars

Got any Excel Questions?Excel Help

Hide & Restore Excel Toolbars in Excel VBA

One of the most exciting parts of Excel is perhaps its ability to be customized to show the end user something quite different. For example, many build their own custom toolbar and distribute them with their Spreadsheet. However, the one question that come up time and time again is ‘how can I hide all of Excel’s toolbars and show only mine when they are using my spreadsheet?’ There are many ways to do this with some being extremely complicated (un-necessarily) through to totally flawed code which leaves the user Starting at a blank screen. The golden rule when/if changing any part of Excel is to make sure it all goes back to how it was when they are not in our specific spreadsheet. In other words,restore the users settings!

Attach Your Toolbar to the Workbook

For this example I will assume you have a custom toolbar called "MyToolbar" and you wish to hideALLof Excel’s built in toolbars and show only "MyToolbar". Before we do so though, it isVITALthat you attach your custom toolbar to the Workbook that will be using it. This will also stop users from being able to make changes stick and ensure you do not get the "The Macro could not be found", or where clicking a toolbar button opening up the Workbook so it can run the macro being clicked. To attach the custom toolbar and over-come these issues, follow the steps below;

1) Open the Workbook that should have the custom toolbar.

2) Right click on any grey unused part of any toolbar and choose "Customize".

3) On the "Toolbars" page check "MyToolbar" (or the applicable name) so it becomes visible.

4) Click "Attach" and then from the "Attach Toolbar" dialog select your toolbar and then click "Copy".

5) Click "Ok" then "Cancel" and it’s done!

You should now be aware that,ANYchanges made to your custom toolbar will not stick (between closing and re-opening the Workbook it’s attached to) unless you first (before any changes) go back to the "Attach Toolbar" dialog and select your toolbar, this time from the right side ("Toolbars in workbook") and then "Delete". Now make any changes needed and then follow steps 1 to 5 again.

Coding the Toolbar Show and Restore

The 2 macros below are what can be used to show your toolbar, remove all native toolbars and most importantly restore them back when done;

The best way to enure these 2 macros are run at the correct time, is to place aRunStatement in the Workbook_Activate, Workbook_Deactivate procedures of the Workbook Object (ThisWorkbook). To get there quickly, right click on the Excel icon top left next to "File" on theWorksheet Menu Barand select "View Code". In here place the code below;

Note the deletion of the custom toolbar when the Workbook closes, this is what prevents any changes sticking unless you have first deleted it (as shown above), made the changes and then attached it again.IMPORTANT:Do not run theApplication.CommandBars("MyToolbar").Deletewhen the custom toolbar isNOT attached.

Special! Free Choiceof Complete Excel Training CourseORExcel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Excel VBA Video Training / EXCEL DASHBOARD REPORTS

Excel Trader PackageTechnical Analysis in Excel With $139.00 ofFREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

How to Find Excel Tool Bar in Excel 2010

In this topic we will learn about how wecan hide toolbars in Excel 2010.

You can Hide Ribbon, Show Tabs and Show tabs with Commands from the bottom top icon of the spreadsheet through the Ribbon Display Option. In Excel this option is available in the top right corner.

  • When youclick on Auto-hide Ribbon, then tabs and commands will disappear from the spreadsheet. When you are working on the sheet, the ribbon will be hidden.

To display the hidden ribbon click on the Ribbon Display Options button again and select Show tabs. This will display only the main tabs. If you want the commands in the tab to be visible, you need to click on the specific tab.

  • To display all the tabs and its commands click on the Ribbon Display Options button and then
    select Show tabs and Commands.

There is another way to show and hide the commands, just double click on the main tab from the ribbon.

The above is the menu which appears when you open the excel file.

So now double click on the “Home” tab as an example and you will that the commands in each tab will disappear.

Now if you double click on the “Home” tab again, you will be able to see the menu commands.

Comments: