Creating a new menu item in EXCEL 1

[logius]

It's been some time since I've used VBA, but I do recall once creating a new drop-down menu in Excel using macros and adding in my own custom functions. The problem is I don't remember how I did it.

Does anyone know how to accomplish this? I'm hoping to insert a menu after the "Help" item at the top of Excel and add in calls to my own functions.

----------------------------------------
If you are reading this, then you have read too far...

 

[SkipVought]

Hi,

Use your macro recorder.

Right click the toolbar

select Customize...

Click [New]

should get you started.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[AnotherHiggins]

->"drop-down menu in Excel"

To create your own addin (which will appear as a menu item along with File, Edit, View etc.), see this article on John Walkenbach's page. There is even a downloadable spreadsheet to get you started.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[logius]

Many thanks! That's exactly what I needed.

----------------------------------------
If you are reading this, then you have read too far...

 

[shetlandbob]

This is also covered in the FAQ

Robert Cumming

http://www.consultantengineer.co.uk