How do I add a macro to a custom menu?

B

Bob Phillips

Where did you store them? They should be in a standard code module. If the
module has Option Private Module at the head, the macros are declared as
private, or they have arguments, you will not see them.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

MikeCyng

Thanks for your response Bob.

They are in a module in the VB editor. I can't see 'Option Private' in the
module and there are no argumants. I can assign the macro to a button but
can't get them as items in a drop down menu.

Cheers
Mike
 
B

Bob Phillips

Are you saying that you have added a dropdown tom a commandbar, and you want
to add your macros to it?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

MikeCyng

Yes, I've added a 'New Menu' to the toolbar and I want to add macros as items
in the drop down menu.
 
Top