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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.