Excel 2007 : 2007 toolbars & menus

[justam]

I recently purchased a new notebook which came with Office 2007.

I have ported my 2003 workbooks across and, like all before me, my productivity dropped to somehting less than zero.

I have googled endlessly for days to solve the following issues, but I am stufed if I can find something to help me. My problem:

A particular workbook in 2003 has toolbars created such that, when I select a sheet, a toolbar exclusive to that sheet will display. When another sheet is selected, the existing toolbar is closed and the toolbar for the sheet selected wwill appear.

In 2007 all toolbars (groups??) and menus appear in the add-in tab which is confusing and not a little dangerous.

Without bothering anyone for a long winded reply, is there a source which explains how I can get the same thing in 2007, where there is a simple explanation of how to assign macros to toolbars, create add-ins etc.?

Anything to help will be most appreciated. (I am in Oz, so any reply from me may be delayed).

Peter

[romperstomper]

Is there a simple explanation? No, not really! I suggest you start with Ron de Bruin's pages on the Ribbon and QAT here, and decide how you want to proceed from there.

[justam]

Thanks Romper. I was very happy writing modest code which worked very well in 2003. My learning curve has just got a whole lot steeper. I find it difficult to undestand why they have made it so much more difficult to do simple things.

[romperstomper]

Unfortunately, the Ribbon changes were largely aimed at people who don't really know how to use Excel. For everyone else, MS seems to assume that if you are customising toolbars and writing code, then you are a developer and therefore the RibbonX and callbacks shouldn't be much of a challenge, especially if you have Visual Studio to work with. Those of us who fall in between those two extremes have to struggle along until they make life a little easier for us (2010 is considerably more user friendly)...