Excel 2007 : Custom Ribbon

Hello,

Does anyone know where I can find a 'simple' guide to creating custom ribbons without using any programs other then Excel 2007 (I cant get additional programs due to company policy).

Thanks

Thanks - But aren't those links examples using Add In's or third party software?
I can use notepad to do it, but i need to find some instructions toe tell me what to edit etc.

Ron de Bruin's link describes how to create the necessary XML file

Regards

Sorry I didnt realise. Ill try it,

Hi Andy - Ive now installed the add in and am working through an example. Ive managed to create a tab but I am unable to insert any items. I can add groups, but it says Cannot Add Item.
Have you seen this before? Am I doing it all wrong?

Thanks

I added a new tab "Ribbon>Tabs>MyTab" then anything I try to add, combobox, button, etc tells me "Button/Combo box/etc cannot be inserted in MyTab.

Thanks

Ah I think ive got it now

This is great - really great and something that MS should have included in this version by default.
I do have one more question for you if thats OK?
Unless ive missed it in your guide, is there a way to have my custom ribbon open in any Excel 2007 workbook I open?
Thanks

Thanks - Ill look at that next.
Is there a way that functions can be called directly rather then as a macro? Such as Print Area?

Sorry - What I mean is, for example, on a normal Excel ribbon i press set print area, and it does exactly that. Is there a way to refer to that existing fucntion rather then create a macro to set print area?

Thanks

Thanks - Thats exactly what I want to do, but ive run into a problem.
Ive change a buttins function to idMSO and removed the ref to the macro, but now when I open the file, my custom ribbon isnt there.
From a backup Ive tried this using AutoFilterClassic, and FileNew.
ASny ideas what Ive done wrong?

Thanks

Hi and thanks for the offer – I started again and so far it seems to be working as I expect.
I've added a gallery button to change font colours, but its not the same as the Home tab button (the Home tab button is a separate button to choose the currently selected colour, and a down arrow to open the palette).
Is there a way to use this button that im not seeing?
Thanks

Hi again Andy. Hope all is good for you.
Ive been working on custom ribbons a bit now but I have a problem that crops up every so often which will cause a headache when/if I need to add controls to the tab.
Last time I started from scratch, but I cant do that each time.
The problem I have is that sometimes, making a change using RibbonX (just changing a tab name, or adding a dialogue launcher), causes the ribbon to vanish when its workbook is open. Also, I added a group for macro's but it doesn't show. Do you know what would cause this? The XML is below. Thanks for any help.

Please Login or Register  to view this content.

Excellent! Many thanks for your quick reply :o)