Hi Jim

First test as Add-in : I see the button but it will not run the code.
If you choose customize QAT you not see it in the icons list in the  "For all documents list"

Ron / Jim,

You learn something everyday. I have never heard of a 'oxymoron' so
just used the word script as it seemed to fit. My apologies.

Jim perhaps l didnt make myself very clear but l think you are
agreeing with me anyway.Perhaps this is clearer:

When l develop a workbook for distribution to end users l want to
avoid them having to add to the QAT (which MS is discouraging), even
if it only needs to be done once. I want the workbook to automatically
create a new tab, group & buttons. On closing the customised tab will
be removed.

My choices are:

A) Full XL Ribbon method - Use XML & callbacks to generate the custom
tab, group & buttons / dropdowns within the group. Each tab, group,
button & dropdown item has to be defined in XML. The appropriate code
is then written in the VBE using the callbacks generated by the Custom
UI Editor. The downside being the amount of effort required by the
developer who may need to learn XML. The benefits being that the end
user uses the same number of clicks to access the macros as in
previous versions of XL.

B) Partial XL Ribbon method - Use the minimum number of XML lines to
create a custom tab, group & button. Use the button callback to invoke
Rons 'MenuMaker'. The benefits of this approach are that most of the
menu building can then be done within the workbook on the 'MenuSheet'
and the resulting popup will be familiar to the end user if upgrading
from previous versions of XL. Downside is that the user will have to
use 1 more mouse click than previously.

For personal use l have created 'MyNewBlankWB-Menu.xlst' which
incorporates Rons 'MenuMaker' so that l can easily develop &
distribute workbooks using method B). I only have to rename the tab,
group & button in XML then add my macro's to the 'MenuSheet' page and
l have a customised XL Ribbon with my defined tab, group & button to
generate the popup.

I am still toying with the idea of a XL.xlst for method A) but cant
decide if its worth the effort as it will probably still need
considerable editing in practice, and Ron's examples cover most
eventualities.

Sorry if its a bit long winded

Regards

Michael Beckinsale.