Macro to create a toolbar

[justaguyfromky]

I have a program that I want to distribute to a couple of other users. I have several modules in a workbook that my supervisor feels would help other manangers in our company. I have used this program for years and have made several updates and rewrites. I had to use the record macro feature to create a toolbar with one button. My question is... How can I include in the code the macro to be assigned to that button and rename the macro when you hover over the button. I am including what recording the macro did for me so far. I am using excel 2000

Application.CommandBars.Add(Name:="ACG Toolbar").Visible = True
Application.CommandBars("ACG Toolbar").Controls.Add Type:=msoControlButton, ID:=2950, Before:=1

I want to hover over the button and see the text "MENU" and have the macro "ACGMenu" macro assigned

Any help would be appreciated

Thanks

Rob