Macro help

T

Thyagaraj

I Want the code to get a ComboBox or DropDown Menu on the excels
Standard toolbar.

Intention is run all the macros with the help of the ComboBox or
DropDown on the standard toolbar.


Thanks in advance

Regards
Thyagaraj
 
F

fugazi48

right click on the toolbar and choose "customize"
Click on Commands tab and choose NEW MENU. Drag the new menu to the toolbar
where you want it.
Click on Macros in the Commands tab and choose New Menu Item. Drag this to
the new menu you created. You need to drop it in a manner that it ends up in
the drop down list for that menu.
Right click on the Item you just created and choose Assign Macro. Choose
the macro you wish to run with that menu item. You can also name it by right
clicking on it.

You can do this for each of your macros to add them all to the toobar.

good luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top