Macro assign to menu

V

Vijay Kotian

I would like to assign macro to a menu and create a drop down menu as per my
requirement, how is it possible to assign macro to a drop down menu, which
is convienient and user friendly instead of creating several toolbars. any
other way to manage serveral toolbars ..... one menu with several dropdown
list for related macros are easy to manage.
 
J

Jack

It sounds like you have already used the Customize function to add macros to
your toolbars. If not look into the help with Cusomize.

If you open the Customize dialog box and scroll to the bottom of the
Categories, you'll see an item called New Menu. Select this.

There is only one Command in the New Menu Category, which is called New Menu.

You can drag this to any location the same as dragging your macros around.
You can create a new main menu, a sub-menu in an existing menu, or a menu on
your toolbar.

This New Menu has the same properties as any of the commands that you drag
out of the Customize dialog box, so you can rename it and add separator
(Begin a Group).

I use this to collect my macros into a couple locations. There are times
where I want a macro to be one-click for the users, so I will put the macro
directly on the toolbar. Otherwise if it is okay to take two or three clicks,
I will organize them in a menu structure.

I hope this helps with your problem.
 
Top