Custom toolbar in excel 2007

[Villiers]

I have an Excel 2003 file that contains a customs toolbar. In Excel 2003, the customs displayed toolbar and I can only toolbar buttons that click to my macros into place. When I open file in Excel 2007 I can find no way to show that customs toolbar. In fact, the only way I found to my macros have access in the macros of the views and to force them to argue that way, which ISN 't that it is cutting. Is there a way in Excel 2007 at the functionality of Excel 2003, maybe by a customs ribbon knots for my macros that tape to continue to build and re-create?

[Raine]

First, there is no customs toolbar in writing in 2007 as a code to make will be absent. You can create ribbons customs, try googling Ribbon X. However, the band adjustment is done via VBA. But anyways, we can try it to do in some other way. Open the workbook and select Customize by right clicking on the quick access toolbar.The drop down box at the top titled 'choose commands from. Click on the drop down and select macros. you will find there a option 'customize quick access toolbar'. Click on the drop down and select the
workbook that commands are to apply to.Select the macro in the left column and click Add. Click a button to change a draft selection. Thats it..

[ThoMas321]

Excel 2007 doesn 't have menus and is instead a "Ribbon" which are very poor design because things don't come up as they had in menus, and to see to be very disorganized out. It 's not bad as it looks, but you will be twice as long to take to get you where, because of all the extra clicks, and broad physical separation of options should be compared to from menus to select. In order to get around that you will use more of the Keyboard Shortcuts in Excel to make.

[Anand D.]

It was simply the tab add-ins to appear on the tape. In theory, that 's how to any customs toolbars are supposed to be shown.The menuing system in Excel 2007 is just short of an abomination, especially for us Excel jocks. I still prefer 2003 over 2007.