Adding an Add-in to a menu

[johncassell]

Hello, hopefully someone can help me with this..

I have created an add-in and saved it. I would now like to be able to select this add-in from a menu (like when i load the auto-save addin, it can be selected from the Tools menu).

And in an ideal situation, I would like to be able to select this from my own Menu (for example, across the top it would have File, Edit, View, Insert, Format, John's Menu).

Can anyone show me how to do this please?

p.s. I am using XL2000

Many thanks

John Cassell

[Ron de Bruin]

Hi

See

How to customize menus and menu bars in Excel
http://support.microsoft.com/default...02&Product=xlw

Creating Custom Menus (John Walkenbach) TIP
http://www.j-walk.com/ss/excel/tips/tip53.htm

Ole P. Erlandsen's Web Site (Example workbooks)
http://www.erlandsendata.no/english/...oadcommandbars




--
Regards Ron de Bruin
http://www.rondebruin.nl


"johncassell" <[email protected]> wrote in message
news:[email protected]...
>
> Hello, hopefully someone can help me with this..
>
> I have created an add-in and saved it. I would now like to be able to
> select this add-in from a menu (like when i load the auto-save addin,
> it can be selected from the Tools menu).
>
> And in an ideal situation, I would like to be able to select this from
> my own Menu (for example, across the top it would have File, Edit,
> View, Insert, Format, John's Menu).
>
> Can anyone show me how to do this please?
>
> p.s. I am using XL2000
>
> Many thanks
>
> John Cassell
>
>
> --
> johncassell
> ------------------------------------------------------------------------
> johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
> View this thread: http://www.excelforum.com/showthread...hreadid=499682
>