Link to the menu template that I use. It makes it easy to create and maintain your menu's. When done just save it as an addin make sure to reference activeworkbook in all of your code in an addin as thisworkbook will reference your addin instead of the sheet you wish to manipulate.

Edit: I forgot the link. http://j-walk.com/ss/excel/tips/tip53.htm