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

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

Hi Ron:

Thanks for the info. I'm still wondering, though, how you managed to
get your AddIn to self-register into the QAT.

Jon


"Ron de Bruin" wrote in message
...
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

You can see how I do it here
http://www.rondebruin.nl/qat2.htm

The button I add manual in this example is saved in the file.
If you open the file your button is also there


--

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


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

Thanks for the info. I'm still wondering, though, how you managed to
get your AddIn to self-register into the QAT.

Jon


"Ron de Bruin" wrote in message
...
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

Hi Ron:

Thanks! I think I read through that example about a dozen times
overnight, but it didn't sink in. (I'm gettin' too old for these
all-nighter programming sessions!) Now I understand how the routine
seemingly auto-registers itself into the menu!

Jon


"Ron de Bruin" wrote in message
...
You can see how I do it here
http://www.rondebruin.nl/qat2.htm

The button I add manual in this example is saved in the file.
If you open the file your button is also there


--

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


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

Thanks for the info. I'm still wondering, though, how you managed to
get your AddIn to self-register into the QAT.

Jon


"Ron de Bruin" wrote in message
...
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