Macros in dropdown menu in Menubar

[ioncila]

Hi

I have created a flying toolbar for all macros in a workbook.

Is it possible to create a dropdown menu in menu bar with all activeworkbook macros, instead creating a flying toolbar or using buttons located is sheets?

Thanks

[Jan Karel Pieterse]

Anything is possible in VBA.
E.g. you could write code that extracts all VBA subroutine names from a workbook. But I think that is overcomplicating things, as alt+F8 already gives you such a list.

[ioncila]

Ok
And the option to fix flying toolbar, for example, in the left side of screen?
How do I do that?

[Jan Karel Pieterse]

You mean put an existing toolbar somewhere or creating a custom toolbar?

[ioncila]

You mean put an existing toolbar somewhere or creating a custom toolbar?

Whenever I open workbook, I want flying toolbar always appear in same place. In this case, in the left side of sheet screen

[Jan Karel Pieterse]

Check out the Position, Left and Top properties of the commandbar object in VBA Help.

[mikerickson]

Excel (pre-2007) command bars can be customized with a button to call the Macro dialog box.

Using that feature might be more stable than a custom command bar.