I have an addin that was written using Excel VBA 2003 and works fine. It
puts a new item in the menu bar just before "Help"

Now the addin is being used in Excel 2007 and it is clear that the macros
are running, but we cannot find out how to get its menu item to display
anywhere.

I guess this is more of an Excel 2007 question than a VBA question, but any
help would be much appreciated!

Thanks!

custom menu items go to add-ins tab in excel 2007. but i think you cannot
control where it go on add-in tabs

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
|I have an addin that was written using Excel VBA 2003 and works fine. It
| puts a new item in the menu bar just before "Help"
|
| Now the addin is being used in Excel 2007 and it is clear that the macros
| are running, but we cannot find out how to get its menu item to display
| anywhere.
|
| I guess this is more of an Excel 2007 question than a VBA question, but
any
| help would be much appreciated!
|
| Thanks!

See Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Check out section on Excel Ribbon and QAT Pages


Gord Dibben MS Excel MVP

On Wed, 19 May 2010 13:38:18 -0400, (E-Mail Removed) wrote:

>I have an addin that was written using Excel VBA 2003 and works fine. It
>puts a new item in the menu bar just before "Help"
>
>Now the addin is being used in Excel 2007 and it is clear that the macros
>are running, but we cannot find out how to get its menu item to display
>anywhere.
>
>I guess this is more of an Excel 2007 question than a VBA question, but any
>help would be much appreciated!
>
>Thanks!