How to create a custom toolbar in excel 2007?

Question

How to create a custom toolbar in excel 2007?

Anonymous

How do I create a custom toolbar in excel 2007?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

2 additional answers

Answer 1

Hi Niranjan,

Click the Microsoft Office Button , and then click Excel Options.
In the list at the left, click Customization.In the Choose commands from drop-down list box, click All commands.In the Customize Quick Access Toolbar box, select either For all documents (default) or a specific document.Click the command that you want to add, and then click Add.

Repeat for each command that you want to add.Click the Move Up and Move Down arrow buttons to arrange the commands in the order in which you want them to appear on the Quick Access Toolbar.Click OK.Alternatively, right click on the Icon on the ribbion that you want on the qucik access toolbar and then click on the option add to quick access toolbar

Answer 2

Anonymous

Microsoft believes you would rather learn to program in VBA code then using the tool customizing menu available in earlier Excelversions. Just sign up to learn VBA at a community college if you want the "paste format" button back.

0 comments

Answer 3

You cannot create custom toolbars in Excel 2007 other than by using either VBA code (which will place your toolbars on the add-ins tab of the ribbon), or by putting icons on the QAT like Niyamath shows you. If you want to modify the ribbon, you'll have to start writing XML code and insert that code into your workbook in a rather unfriendly way. See:

http://www.jkp-ads.com/Articles/DistributeMacro03.asp

Share via

How to create a custom toolbar in excel 2007?

2 additional answers