I wrote a macro to create a custom menu for a specific workbook. This menu is
not needed for any other workbook and is deleted upon closing. How do I
assign, via code, a macro to run when this button is clicked?

Thank you

In the code that creates the menu item, use the onaction property to assign
it to a macro. If you are fuzzy on the code, if after you create the menu,
then turn on the macro recorder and do Tools->customize - leave the dialog
displayed and right click on the bottm and assign a macro. Then drop the
dialog and turn off the macro recorder. Look at the recorded code.

--
Regards,
Tom Ogilvy


"Harley" wrote:

> I wrote a macro to create a custom menu for a specific workbook. This menu is
> not needed for any other workbook and is deleted upon closing. How do I
> assign, via code, a macro to run when this button is clicked?
>
> Thank you

You set the OnAction property of the control to your macro when creating it.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Harley" <(E-Mail Removed)> wrote in message
news:89A04CF5-06E2-4189-8DD9-(E-Mail Removed)...
> I wrote a macro to create a custom menu for a specific workbook. This menu
is
> not needed for any other workbook and is deleted upon closing. How do I
> assign, via code, a macro to run when this button is clicked?
>
> Thank you