Hi Jon

You try this example
http://www.rondebruin.nl/qat.htm
You can simple edit the menu in this example and copy your code in it.
No need to create a new add-in

If you want to see the steps see
http://www.rondebruin.nl/qat2.htm

--

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


"JonWestcot" wrote in message ...
Hi all:

Trying here to use Ron's sample code for creating an Excel menu of macro
entries that would exist in a single AddIn. I downloaded his "For My
Add-in.xlam" and enabled it as an AddIn. It worked wonderfully. I then
tried to create my own code for creating a similar menu and have had nothing
but problems.

Questions:

1) What causes the small green arrow icon to appear on the menu bar when
the AddIn is instantiated? I can't find this example anywhere!

2) I have seven macros that need to be accessible from the menu. I simply
hard-coded the references since there have been seven items for this menu
for at least the last 10 or more years (the application is legacy from Lotus
1-2-3). They seem to add, and the CommandBar appears to be present, but I
cannot make it visible. Doing so generates an error.

3) How can I get the menu item (the green arrow icon) to appear like it
does in Ron's sample?

Any help will be greatly appreciated!

Thanks,

Jon