Prev: How to update .xlam file (add-in) while it is in use?
Next: Not sure what to call this
From: NoSpam on 19 May 2010 13:38
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!
From: Homey on 19 May 2010 14:19
custom menu items go to add-ins tab in excel 2007. but i think you cannot
control where it go on add-in tabs

<NoSpam(a)aol.com> wrote in message
news:b988v519kbcelnivjqnqjj4kl4qd0e4hu3(a)4ax.com...
|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!

From: Gord Dibben on 19 May 2010 15:48
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, NoSpam(a)aol.com 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!

 | 
Pages: 1
Prev: How to update .xlam file (add-in) while it is in use?
Next: Not sure what to call this