ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro help (https://www.excelbanter.com/excel-programming/365795-macro-help.html)

Thyagaraj

Macro help
 
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


fugazi48

Macro help
 
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.




"Thyagaraj" wrote:

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




All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com