Macro to create a toolbar

**justaguyfromky** · 03-13-2011, 01:48 PM

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

**Greg M** · 03-13-2011, 09:00 PM

Hi there,

Try the following code and see if it does what you need. I've added a few extra parameters for you to play with if you feel like experimenting a bit

Please Login or Register  to view this content.

I hope this helps - please let me know how you get on.

Regards,

Greg M

**pike** · 03-13-2011, 09:07 PM

or maybe another way ..

Please Login or Register  to view this content.

**royUK** · 03-14-2011, 04:51 AM

Which version of Excel? If 2007 or later then Menus are not supported.

Add_Toolbar.zip

AddMenu.zip

**pike** · 03-15-2011, 03:09 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save