How do i create menu to run macro

[Miya]

Hi, i would like to run macros from menu, how could I achieve this?

 

[c_m]

you could create a custom menu or a toolbar icon and assign a macro to it.
View>>Toolbars>>Customize>>run down to Macro>>see the options on the right side...explore them

 

[Miya]

you could create a custom menu or a toolbar icon and assign a macro to it.
View>>Toolbars>>Customize>>run down to Macro>>see the options on the right side...explore them

I was after a VBA approach

 

[tusharm]

See John Walkenbach's http://spreadsheetpage.com/index.php/file/menu_maker/