View Single Post
  #5   Report Post  
MikeCyng
 
Posts: n/a
Default How do I add a macro to a custom menu?

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

"Bob Phillips" wrote:

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)


"MikeCyng" wrote in message
...
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

"Bob Phillips" wrote:

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)


"MikeCyng" wrote in message
...
I can't find my macros in the customize/commands list