Can someone direct me to some standard instuctions on how to link a macro to
a drop-down menu item? I want a new menu item called "Macros", with a
shortcut code M, then all my macros would be under that, numbered 1-6, with
the shortcut being the number.

I also want to share the add-in with my colleagues easily.

Thanks in advance
Daniel

I think there may be a few different ways to do this. It can be accomplished
from programmatically from code, for instance, maybe in the setup procedure
for your addin (if you choose to distribute it that way.) Here's how I do it
manually in XL2003: Right click on your menu bar and select customize.
Choose the Commands tab. From here you can drag a, "New Menu," onto an
existing menu bar, and you can also add, "Macros," by dropping custom
buttons onto your menu and assigning them to procedures.

That should get you started. :)

-Mike

"Daniel Bonallack" wrote in
message ...
Can someone direct me to some standard instuctions on how to link a macro
to
a drop-down menu item? I want a new menu item called "Macros", with a
shortcut code M, then all my macros would be under that, numbered 1-6,
with
the shortcut being the number.

I also want to share the add-in with my colleagues easily.

Thanks in advance
Daniel

Thanks Mike!

"Mike Mertes" wrote:

I think there may be a few different ways to do this. It can be accomplished
from programmatically from code, for instance, maybe in the setup procedure
for your addin (if you choose to distribute it that way.) Here's how I do it
manually in XL2003: Right click on your menu bar and select customize.
Choose the Commands tab. From here you can drag a, "New Menu," onto an
existing menu bar, and you can also add, "Macros," by dropping custom
buttons onto your menu and assigning them to procedures.

That should get you started. :)

-Mike

"Daniel Bonallack" wrote in
message ...
Can someone direct me to some standard instuctions on how to link a macro
to
a drop-down menu item? I want a new menu item called "Macros", with a
shortcut code M, then all my macros would be under that, numbered 1-6,
with
the shortcut being the number.

I also want to share the add-in with my colleagues easily.

Thanks in advance
Daniel