Newbie: add menu item..

[Stuart McMahon]

Hi,
I am new to Excel programming.
I would like to add a new Menu to Excel (beside the Help Menu preferably)
and add several Menu Items to it.
Some of these Menu Items will launch dialog boxes.
Is this possible??

Stuart.

[Tom Ogilvy]

Here are some sources of information if you are interested in learning how
to work with commandbars. If you just want sample code, I am sure someone
will post some:

http://support.microsoft.com/support/kb/articles/Q159/6/19.asp
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/support/kb/articles/Q213/5/50.ASP
XL2000: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/support/kb/articles/Q166/7/55.asp
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.

http://msdn.microsoft.com/library/techart/ofcmdbar.htm

Regards,
Tom Ogilvy

"Stuart McMahon" <Stuart....@PredictionDynamics.com> wrote in message
news:a9ecrc$129$1...@kermit.esat.net...

[Dave Peterson]

On top of what Tom wrote, you may find John Walkenbach's MenuMaker utility easy
to use.

http://j-walk.com/ss/excel/tips/tip53.htm

When you're there, take a look at his help system.

http://j-walk.com/ss/excel/tips/tip51.htm

--

Dave Peterson
ec3...@msn.com