Excel 2007 Function Library

[BK]

Is it possible to customize the Excel Function Library group? For example, I
would like add the Statistical functions as an option and perhaps remove one
of the less used buttons (Text). I know I can add the Statistical function to
the QAT, but I'd prefer to add it as a button on the Function Library group.
Does anyone know if this is possible? THANKS! BK

 

[Ron de Bruin]

Hi BK

You can change the ribbon

You can't add a button to a built-in group

This example will add a group next to the Excel Function Library group with the gallery you want
See how you can add the xml to a workbook here
http://www.rondebruin.nl/ribbon.htm

If you want to see it in all your workbooks then save it in a add-in

If you really want one group you can hide the whole function group and create a new one with
the buttons you want.


<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

<!-- Add Custom group to the Formulas tab in the ribbon-->
<!-- The example add a gallery named FunctionsStatisticalInsertGallery-->

<ribbon>
<tabs>

<tab idMso="TabFormulas" >
<group id="customGroup1" label="Group 1" insertBeforeMso="GroupNamedCells" >
<gallery idMso="FunctionsStatisticalInsertGallery" size="large" />
</group>
</tab>

</tabs>
</ribbon>
</customUI>