PDA

View Full Version : Macros in dropdown menu in Menubar



ioncila
12-16-2009, 05:30 AM
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
12-16-2009, 07:21 AM
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
12-16-2009, 08:08 AM
Ok
And the option to fix flying toolbar, for example, in the left side of screen?
How do I do that?

Jan Karel Pieterse
12-16-2009, 08:46 AM
You mean put an existing toolbar somewhere or creating a custom toolbar?

ioncila
12-16-2009, 09:30 AM
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
12-16-2009, 02:56 PM
Check out the Position, Left and Top properties of the commandbar object in VBA Help.

mikerickson
12-16-2009, 05:55 PM
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.