Add In's Custom Menu

[xEnOnn]

I have a XLA that has a macro custom menu in it. I tried to add te XLA through te Add In option in Excel and the menu appears. However, when I close Excel and open it again, the custom menu is gone. In the Add In window, the XLA file Add In is still checked which means it is still installed. But how come the custom menu is gone if it is still installed? I have to uninstall and reinstall the XLA file again to get back the menu.

Is it possible to let the custom menu to stay until the user uninstalls the XLA file from the Add In option window? Right now, this happens even when I did not run any code to remove the menu in the XLA workbook's addin_uninstall event. But the menu is created in its addin_install event.

Thanks.

[xEnOnn]

Anyone has any idea on this?

[Siddharth Rout]

The method that you are using is absolutely correct. The rest I will be able to comment, after I see the Addin's code. Can you upload the Addin?

[xEnOnn]

I am following the code completely from http://www.ozgrid.com/VBA/custom-menus.htm

The menu appears when I installs the Add in but disappear after I close and reopen Excel even though I did not uninstall the Add in. I am using Excel 97. I need the menu to stay until I uninstall the add in, then the menu deletes itself as the deletemenu function code is run.

Thanks.

[Siddharth Rout]

I am following the code completely from http://www.ozgrid.com/VBA/custom-menus.htm

The menu appears when I installs the Add in but disappear after I close and reopen Excel even though I did not uninstall the Add in. I am using Excel 97. I need the menu to stay until I uninstall the add in, then the menu deletes itself as the deletemenu function code is run.

Thanks.

Excel 97... Hmmm, I don't even remember how does it look like

There is nothing wrong in the code in that link. It all matters on how are you using the code. Can I see your file?

[xEnOnn]

I have tried on my other computer on Office 2003 and it works. The menu stays even after I close excel.

The office 97 is actually what my office computers are still using. The menu doesn't stay after I close and reopen excel. I do not have admin rights on the computer in my office. Could this be the problem?

Also, my Add In file is placed on the desktop.

I have attached the file that I was trying to this post.