View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Excel 2007 Function Library

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"BK" wrote in message ...
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