How to create Excel Add-in with custom drop down menu for other users

[RiaM]

Hi guys

Been a while since I've been on here and its good to be back. I've written a ton of VB macros that do various things to a raw data sheet. I want now to create a custom menu (in the the menu ribbon bar at the top of the screen). I'd like this menu to be used to activate the various macros for whoever has my add-in.

I've found several examples on how to create an add-in, and creating custom menus, however they all for when someone opens a workbook with the code, and then they remove the custom menu when the workbook is closed. I would like my custom menu to stay on the users ribbon bar no matter what workbook they have open. The only time the custom menu should not appear is if the user removes the add-in.

Can someone please assist?

Many thanks
Ria

 

[RiaM]

Anyone?

 

[Fazza]

hi, Ria

If you're in Excel 2003 I can assist tomorrow - nearly beer o'clock here

cheers

 

[RiaM]

Hi Fazza

Beer o clock Its about that time over here too! No worries, but I'm on 2010, sorry - should have put that in the original post.

Cheers,
Ria

 

[RiaM]

bump. Anyone?

 

[Jaafar Tribak]

If the code that creates the ribbon menu is in the AddIn then it should stay there for all workbooks .

 

[RiaM]

If the code that creates the ribbon menu is in the AddIn then it should stay there for all workbooks .

Thank you, it was just silliness on my part. Many thanks for your point that made me think