This topic is now archived and is closed to further replies.


VB, Excel and Menus

Recommended Posts

G''day folks, I am having some trouble creating menus and menu items with VB macros in Excel. I want to create a menu on the menu bar (say next to the help menu) for reports, with each selection in the menu kicking off it''s own macro. I have tried using the "record new macro" and created one manually, but not all of the selections I make (eg. the menu name, macro selections) seem to make it to the macro. I am trying to use : Application.CommandBars("Worksheet Menu Bar").Controls.Add msoControlPopup, "Report" Is this the right way to go about it, and if so, how do I then access that particular menu bar item? Any help is much appreciated. Thanks.

Share this post

Link to post
Share on other sites