Put Addin on Menu Bar Tab in 2007

[Eldrod]

I've been searching all over and have not been able to find this, so I'm hoping soneone else knows how to do this. I have a macro that loads itself to Excel 2007's Addin tab on the ribbon via:

Application.CommandBars("Worksheet Menu Bar")

But I really want to have it create it's own tab on the ribbon instead on residing in the Menu Commands box of the Addin Ribbon tab.
Anyone know how to do this?
TIA!

 

[JonRowland]

Hi Eldrod,

I've just done the same thing myself. I found the following website useful to learn what is required to create your own tab.

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

Hope this helps you.

Jon

 

[Eldrod]

Jon, Funny but I was reading that exact website when your reply came in. Thanks and I hope I can figure it out from there.