How do I add a macro to a custom menu?

[MikeCyng]

I can't find my macros in the customize/commands list

[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)


"MikeCyng" <MikeCyng@discussions.microsoft.com> wrote in message
news:B01A9FAB-3AA3-4CB2-81AB-BFC9546F1767@microsoft.com...
> I can't find my macros in the customize/commands list

[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

"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" <MikeCyng@discussions.microsoft.com> wrote in message
> news:B01A9FAB-3AA3-4CB2-81AB-BFC9546F1767@microsoft.com...
> > I can't find my macros in the customize/commands list
>
>
>

[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)


"MikeCyng" <MikeCyng@discussions.microsoft.com> wrote in message
news:E62F62CE-62E1-4C69-9255-62CB4D42A014@microsoft.com...
> 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" <MikeCyng@discussions.microsoft.com> wrote in message
> > news:B01A9FAB-3AA3-4CB2-81AB-BFC9546F1767@microsoft.com...
> > > I can't find my macros in the customize/commands list
> >
> >
> >

[MikeCyng]

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" <MikeCyng@discussions.microsoft.com> wrote in message
> news:E62F62CE-62E1-4C69-9255-62CB4D42A014@microsoft.com...
> > 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" <MikeCyng@discussions.microsoft.com> wrote in message
> > > news:B01A9FAB-3AA3-4CB2-81AB-BFC9546F1767@microsoft.com...
> > > > I can't find my macros in the customize/commands list
> > >
> > >
> > >
>
>
>

[MikeCyng]

I've finally managed to find a website which answers my question -
http://www.aicpa.org/pubs/jofa/jul2001/lenning.htm
I can see were i was going wrong now!

Thanks for taking the trouble to reply.

Cheers
Mike

"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" <MikeCyng@discussions.microsoft.com> wrote in message
> news:E62F62CE-62E1-4C69-9255-62CB4D42A014@microsoft.com...
> > 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" <MikeCyng@discussions.microsoft.com> wrote in message
> > > news:B01A9FAB-3AA3-4CB2-81AB-BFC9546F1767@microsoft.com...
> > > > I can't find my macros in the customize/commands list
> > >
> > >
> > >
>
>
>

[Dave Peterson]

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

MikeCyng wrote:
>
> I can't find my macros in the customize/commands list

--

Dave Peterson