Creating an Add-In can't get custom menu working

Hi,

I am trying to create a new add in for excel. I have the add in created but I cant get a new custom menu working. It will not show up on the menu bar no matter what code I throw at it. I am new at doing this type of thing so I must be doing something wrong but I can't figure out what.

I had been following instructions on this website:

http://www.ozgrid.com/VBA/excel-add-in-create.htm

Like I said I have the add-in created as an xla and when I run it from the VB editor t runs fine and the macro will run int he document. I am going to be distributing this addin to a few clients and just want to create a simple menu on the menu bar to be able to run the macro in the add-in but even though I used the code on that website no new menu is being added to excel.

I am adding this code into "ThisWorkbook" in VB under the xla I made.

Here is the code I am using:

Please Login or Register  to view this content.

Any help would be great.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I've added code tags this time. Your menu will only be displayed when the addin is installed

Your code may be suppressing errors that area occurring. Try:

Please Login or Register  to view this content.

I assume you are not in fact using 2007 (or later).