I'm not sure about the VBA code, but when I made my own Menu I used the menu maker at this link. http://www.j-walk.com/ss/excel/tips/tip53.htm
When I had modified the menu to my own things, I changed the code so that the message about creating a new menu didn't come up everytime you opened the menu maker file.
Once I'd done that, I saved the menu maker file in the XLStart folder in my Office files in Program Files so that it opens everytime I open Excel and automatically makes my menu.
The only problem with doing that is, you see the menu maker everytime excel opens so I clicked Window and Hide and saved it when I closed. Now the menu maker doesn't appear when I load Excel but it loads my menu.
I know it's not the most professional way to make a menu but it works.
I'm sorry I can't help you with the code because I'm not too good with VBA code... that's why I come here for help everyday!